Identity Column

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

    Thanks,
    Shiva N
    Database Consultant

  • Nice question shiva, thanks for the reminder 🙂

    ...

  • This was removed by the editor as SPAM

  • 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!

    🙂

  • Oww, my eyes.

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

  • 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

  • Thanks for the question.

  • 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

  • Thanks for the question.

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

  • 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

  • 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