Identity Column

  • Shiva N

    Hall of Fame

    Points: 3125

    Comments posted to this topic are about the item Identity Column

    Thanks,
    Shiva N
    Database Consultant

  • HappyGeek

    SSCoach

    Points: 18678

    Nice question shiva, thanks for the reminder 🙂

    ...

  • This was removed by the editor as SPAM

  • Ed Wagner

    SSC Guru

    Points: 286980

  • sknox

    SSChampion

    Points: 12284

    This question is almost more about TRUNCATE than IDENTITY. All of the inserts before the TRUNCATE are just red herrings. But made me think of the following SQL forum joke:

    TRUNCATE TABLE Comments;

    First!

    🙂

  • Xavon

    SSCrazy

    Points: 2280

    Oww, my eyes.

    But other than the formatting, it was a simple, red herring question.

  • TomThomson

    SSC Guru

    Points: 104773

    sknox (10/5/2015)


    This question is almost more about TRUNCATE than IDENTITY. All of the inserts before the TRUNCATE are just red herrings.

    To some extent I agree, but I would say that you have to know what inserting a row in a brand new table does to its identity column as well as knowing that TRUNCATE puts the table into the brand new state.

    Of course I haven't a clue why the author thought that the remark in the explanation about a table not having multiple identity columns had any connection with the question or the answer .:rolleyes:

    Apart from the explanation it's quite a nice question. 😎

    Tom

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Lots of code that could have been avoided 😀

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

  • pmadhavapeddi22

    SSCertifiable

    Points: 5306

    Thanks for the question.

  • stephen.long.1

    SSCrazy

    Points: 2577

    I agree with Tom that the statement about multiple identity columns had nothing to do with the question. Otherwise, it's a nice, simple question when you see the TRUNCATE TABLE statement. Thanks, Shiva.

  • SQLRNNR

    SSC Guru

    Points: 281243

    TomThomson (10/5/2015)


    sknox (10/5/2015)


    This question is almost more about TRUNCATE than IDENTITY. All of the inserts before the TRUNCATE are just red herrings.

    To some extent I agree, but I would say that you have to know what inserting a row in a brand new table does to its identity column as well as knowing that TRUNCATE puts the table into the brand new state.

    Of course I haven't a clue why the author thought that the remark in the explanation about a table not having multiple identity columns had any connection with the question or the answer .:rolleyes:

    Apart from the explanation it's quite a nice question. 😎

    +1

    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

  • patricklambin

    SSCrazy Eights

    Points: 9964

    TomThomson (10/5/2015)


    sknox (10/5/2015)


    This question is almost more about TRUNCATE than IDENTITY. All of the inserts before the TRUNCATE are just red herrings.

    To some extent I agree, but I would say that you have to know what inserting a row in a brand new table does to its identity column as well as knowing that TRUNCATE puts the table into the brand new state.

    Of course I haven't a clue why the author thought that the remark in the explanation about a table not having multiple identity columns had any connection with the question or the answer .:rolleyes:

    Apart from the explanation it's quite a nice question. 😎

    +1 but I think I have stolen 1 point because it is a trivial question....

Viewing 13 posts - 1 through 13 (of 13 total)

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