Legal/illegal characters in table name

  • sendijunk

    Mr or Mrs. 500

    Points: 534

    Comments posted to this topic are about the item Legal/illegal characters in table name

  • MyDoggieJessie

    SSC-Forever

    Points: 44276

    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    ______________________________________________________________________________
    Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • Carlo Romagnano

    SSC-Insane

    Points: 21790

    MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1

    Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

    :w00t:

  • dbafromthecold@gmail.com

    SSChampion

    Points: 10074

    MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    Yep:-

    Msg 2760, Level 16, State 1, Line 1

    The specified schema name "tmp" either does not exist or you do not have permission to use it.

  • free_mascot

    One Orange Chip

    Points: 27168

    Carlo Romagnano (4/8/2015)


    MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1

    Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

    :w00t:

    +1

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

  • Mauricio_

    SSCrazy

    Points: 2813

    +1

    I was going to write exactly the same 🙂

  • Koen Verbeeck

    SSC Guru

    Points: 258938

    Nice question, but a bit of an oversight on the tmp schema.

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

  • Bhaskar.Shetty

    Hall of Fame

    Points: 3054

    Same Here.. +1

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thanks for the post, good one.

    I was of sure of usage of square brackets will lead to the successful table creation, and that "tmp." schema name- as not all databases will have it, so I thought "well yea... error".

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    Good question. Possible but not practical.

    Igor Micev,
    My blog: www.igormicev.com

  • Sean of the Lynchmob

    Ten Centuries

    Points: 1038

    I got this when I ran it:

    Msg 2760, Level 16, State 1, Line 1

    The specified schema name "tmp" either does not exist or you do not have permission to use it.

    .....and no table created. So I have to disagree with the "correct" answer.....

  • Toreador

    SSChampion

    Points: 11230

    Like some others, I guessed wrongly that the "trick" to this question was about the schema 🙁

  • This was removed by the editor as SPAM

  • Hany Helmy

    SSChampion

    Points: 13321

    MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1, this should have been mentioned in the question.

  • Hany Helmy

    SSChampion

    Points: 13321

    Stewart "Arturius" Campbell (4/8/2015)


    Good question, despite the tmp schema "issue"

    Highlights the difference between what is possible and what is practical.

    True, this is possible but not practical @ all, who will ever think about naming a table (char(13))?! 😀

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

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