Identity Values

  • Orlando Colamatteo

    SSC Guru

    Points: 182269

    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

  • kalyani.k478

    Default port

    Points: 1400

    +1 🙂 thanks

  • manik_anu


    Points: 2367

    nice question..... 😎

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

  • Dineshbabu

    Hall of Fame

    Points: 3220

    Nice question.

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

    Desire to learn new things..

  • This was removed by the editor as SPAM

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • sqlnaive


    Points: 17435

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

  • ajit.ghule

    Mr or Mrs. 500

    Points: 598

    Nice Question.:-)

  • Lokesh Vij


    Points: 10836

    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 -->[/url]

    Follow me @Twitter

  • Gazareth

    One Orange Chip

    Points: 27737

    Good question, this behaviour could be a gotcha.

  • (Bob Brown)


    Points: 2705

    Thanks the great midweek question.

  • Raghavendra Mudugal


    Points: 10658

    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.

  • Thomas Abraham


    Points: 10761

    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

  • Vinay Kumar


    Points: 6098

    Good question. In hurry i picked wrong.. 🙁

    Vinay Kumar
    Keep Learning - Keep Growing !!!

  • Bob JH Cullen


    Points: 2082

    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 39 total)

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