TSQL - Identity_Insert

  • psingla

    Hall of Fame

    Points: 3840

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

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014

    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

  • kapil_kk

    SSC-Insane

    Points: 21316

    Good question to start the day 🙂

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • 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

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    Good Question and nice explanation....

  • Nick Doyle

    SSC Eights!

    Points: 926

    Good question for this early in morning. Thanks

  • Dana Medley

    SSCertifiable

    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.

    Tom

  • twin.devil

    SSC-Insane

    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.

    J:hehe:

  • SQLRNNR

    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
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Carlo Romagnano

    SSC-Insane

    Points: 21984

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

  • manik_anu

    SSCrazy

    Points: 2367

    nice question....:-)

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

  • sqlnaive

    SSCoach

    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

    SSCommitted

    Points: 1545

    :blush:

    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

    SSCrazy

    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