Schema & Renaming Fun

  • Andy Warren

    SSC Guru

    Points: 119676

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

  • free_mascot

    One Orange Chip

    Points: 27168

    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."

  • pmadhavapeddi22

    SSCertifiable

    Points: 5306

    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.

  • Carlo Romagnano

    SSC-Insane

    Points: 21864

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

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

    Bad wording?

  • Hany Helmy

    SSChampion

    Points: 13436

    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

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Great question, thanks!

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

  • Toreador

    SSChampion

    Points: 11247

    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

  • palotaiarpad

    SSCarpal Tunnel

    Points: 4893

    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?

  • OCTom

    SSChampion

    Points: 11755

    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

    😀

  • Carlo Romagnano

    SSC-Insane

    Points: 21864

    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].

  • Andy Warren

    SSC Guru

    Points: 119676

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

  • Andy Warren

    SSC Guru

    Points: 119676

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

  • SQLRNNR

    SSC Guru

    Points: 281233

    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

  • Mike Hays

    SSCommitted

    Points: 1871

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

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

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