Identity Values

  • Comments posted to this topic are about the item Identity Values

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • +1 🙂 thanks

  • nice question..... 😎

    Manik
    You cannot get to the top by sitting on your bottom.

  • Nice question.

    From the explaination I understood even duplicate values can be generated using DBCC CHECKIDENT.

    --
    Dineshbabu
    Desire to learn new things..

  • This was removed by the editor as SPAM

  • Great question thanks. I vaguely remember seeing a similar QotD once, but it's quite some time ago.

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

  • It was a basic but very good question. I was in little confusion over the second value but when concentrated, got it right and earned 1 point. 🙂

  • Nice Question.:-)

  • Good one. Thanks!

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Good question, this behaviour could be a gotcha.

  • Thanks the great midweek question.

  • Simply the best. thank you for posting..

    (even though got the wrong answer, and really not sure why i considered the check-box as radio-buttons and then clicked only 101... and then #facepalm)

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

  • Thanks for the question. Always good to highlight things that have surprising behaviors.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Good question. In hurry i picked wrong.. 🙁

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • OK. I got it wrong because I tried to apply what I thought was sensible logic to the choice of the second value. Can anyone explain why SQL uses such bizarrely inconsistent behaviour?

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

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