Object_Id 1

  • Comments posted to this topic are about the item Object_Id 1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thanks for the easy question. 😀

  • Does the collation actually make a difference here, or was that included as a bit of misdirection?

  • But there is a documentation that it must be uppercase: ms179899 🙂

  • Thanks for the easy question - nice to check the basics again.

  • YAY!!!. I got one point.

    (representation of N - has nothing to do with the collation)

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

  • Made me think for a minute and I got my point. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • And once again I fail as a T-SQL parser.

  • good question!

    thanks!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Good syntax question; not sure why collation info was included. Thanks!

  • Nice easy question, nice straightforward answer and explanation.

    I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?

    Tom

  • SQL Kiwi (2/23/2012)


    And once again I fail as a T-SQL parser.

    +1

  • Needed a simple one today. Thanks for the question.

  • EZ PZ lemon SQeZ

    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

  • L' Eomot Inversé (2/23/2012)


    Nice easy question, nice straightforward answer and explanation.

    I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation is ..._CI_.. ?

    Your absolutely correct, and since QOD can be / or is a teaching tool for some I felt it was a little plus item to show

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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