Schema & Renaming Fun

  • Comments posted to this topic are about the item Schema & Renaming Fun

  • Good Question. Getting +2 questions continuous in a row 🙂

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Thanks for the question.

    You have given a hint in QOD to select one option out of 3.

    --CLEANUP:

    --use master

    --drop database xSchemingFun

    --drop login qodschemingfun

    The above hint tells that database and login will be created successfully.

  • "Schema cannot be named Not" ?????

    "It could be said the table is not funny" ????

    Bad wording?

  • pmadhavapeddi22 (3/12/2014)


    Thanks for the question.

    You have given a hint in QOD to select one option out of 3.

    --CLEANUP:

    --use master

    --drop database xSchemingFun

    --drop login qodschemingfun

    The above hint tells that database and login will be created successfully.

    + 1

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Great question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Interesting question, just a shame that it's let down (as QOTDs so often are) by case inconsistencies.

    On a case sensitive database you get several errors and end up with a table called "ny".

  • This was removed by the editor as SPAM

  • Hmmm.

    According to BOL 'not.funny' should be treated as a failure:

    [ @newname = ] 'new_name'

    Is the new name for the specified object. new_name must be a one-part name and must follow the rules for identifiers. newname is sysname, with no default.

    Or does it mean, no space allowed in new_name?

  • I found this to be fun and funny and not very .not.funny.

    I was first screaming about the scheming. After I realized what was up, it brought a smile to my face.

    Tom

    😀

  • palotaiarpad (3/12/2014)


    Hmmm.

    According to BOL 'not.funny' should be treated as a failure:

    [ @newname = ] 'new_name'

    Is the new name for the specified object. new_name must be a one-part name and must follow the rules for identifiers. newname is sysname, with no default.

    Or does it mean, no space allowed in new_name?

    'not.funny' is just a name as [not.funny].

  • Thanks for the comment on the hint in the cleanup - good catch for you, dumb mistake for me:-)

  • I'll try to remember the case sensitivity going forward and add it to my list of things to check.

  • Thanks Andy. On a not.funny note, this was a good question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Well, I thought I knew my reserved words....

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply