Post reply

Identity Column

  • October 4, 2015 at 2:20 am

    #312058

    Comments posted to this topic are about the item Identity Column

    Thanks,
    Shiva N
    Database Consultant

  • October 4, 2015 at 2:23 am

    #1831255

    Nice question shiva, thanks for the reminder 🙂

    ...

  • October 4, 2015 at 11:54 pm

    This was removed by the editor as SPAM

  • October 5, 2015 at 5:15 am

    #1831331

    Thanks, Shiva.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • October 5, 2015 at 6:24 am

    #1831353

    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!

    🙂

  • October 5, 2015 at 6:38 am

    #1831359

    Oww, my eyes.

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

  • October 5, 2015 at 6:54 am

    #1831364

    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

  • October 5, 2015 at 1:00 pm

    #1831508

    Thanks for the question.

  • October 6, 2015 at 2:55 am

    #1831622

    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

  • October 7, 2015 at 7:12 am

    #1831980

    Thanks for the question.

  • October 8, 2015 at 7:52 am

    #1832284

    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.

  • October 31, 2015 at 2:38 pm

    #1836874

    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

  • November 4, 2015 at 3:53 am

    #1837578

    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 12 (of 12 total)

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