TSQL - Identity_Insert

  • psingla

    Hall of Fame

    Points: 3840

    Comments posted to this topic are about the item TSQL - Identity_Insert

    SQL Server DBA | MCSE SQL Server 2012/2014


  • kapil_kk


    Points: 21316

    Good question to start the day 🙂

    To get quick answer follow this link:

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Interesting question, thanks.

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



    Points: 5507

    Good Question and nice explanation....

  • Nick Doyle

    SSC Eights!

    Points: 926

    Good question for this early in morning. Thanks

  • Dana Medley


    Points: 6764

    Thanks for the question!

    Everything is awesome!

  • TomThomson

    SSC Guru

    Points: 104773

    Interesting question. I'm surprised so many got it right - surely people don't use identity insert so much that they either know this from experience or have taken care to learn it so as not to find out the hard way? Certainly it's something I must have known once (when first learning to use SQL Server, some time in the mists of antiquity) but I had completely forgotten it so I got it wrong. So it was a useful reminder for me.


  • twin.devil


    Points: 22208

    good question ... thanks

  • JAZZ Master

    Hall of Fame

    Points: 3292

    The past two years I have been handling data migration, so I have had to use this quite a bit. Nice easy question for a day that feels like Monday.



    SSC Guru

    Points: 281243

    Thanks for a nice and easy midweek question

    Jason...AKA CirqueDeSQLeil
    I have given a name to my pain...MCM SQL Server, MVP
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Carlo Romagnano


    Points: 21984

    In the past 10 years, I played a lot with SET identity_insert. I'm a specialist!

  • manik_anu


    Points: 2367

    nice question....:-)

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

  • sqlnaive


    Points: 17435

    I've been playing with identity columns quite lot in the past two years so found it easy to resolve. But nice question. Cheers 🙂

  • Dscheypie


    Points: 1545


    If I hadn't tried it out I would have gotten it wrong.

    :blush: again...

    ...is this English grammar correct, by the way?

    If you set out to do something, something else must be done first.

  • logitestus


    Points: 2877

    :blush: umm, what should you do when you can't perform simple math in your head? This was a pretty simple question (since I have been dealing with IDENTITY_INSERT for several years now) but the simple addition of 100 + 1 + 1 trips me up? Time to back to the dunce cap...

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

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