TSQL - Identity_Insert

Question

TSQL - Identity_Insert

psingla

Hall of Fame

Points: 3840
More actions
August 20, 2013 at 10:45 pm

#297912

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/

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

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

kapil_kk SSC-Insane Points: 21316 More actions · Answer 1

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: 259105 More actions · Answer 2

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 More actions · Answer 3

PRAMANA.DBA

SSCertifiable

Points: 5507

August 21, 2013 at 12:00 am

#1643311

Good Question and nice explanation....

Nick Doyle SSC Eights! Points: 926 More actions · Answer 4

Nick Doyle

SSC Eights!

Points: 926

August 21, 2013 at 6:36 am

#1643419

Good question for this early in morning. Thanks

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

Dana Medley

SSCertifiable

Points: 6764

August 21, 2013 at 7:08 am

#1643430

Thanks for the question!

Everything is awesome!

TomThomson SSC Guru Points: 104773 More actions · Answer 6

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

Umer Akram SSC-Insane Points: 22209 More actions · Answer 7

Umer Akram

SSC-Insane

Points: 22209

August 21, 2013 at 8:13 am

#1643483

good question ... thanks

Julie Hall of Fame Points: 3292 More actions · Answer 8

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: 281334 More actions · Answer 9

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: 22668 More actions · Answer 10

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

manik_anu SSCrazy Points: 2377 More actions · Answer 11

nice question....:-)

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

sqlnaive SSCoach Points: 17437 More actions · Answer 12

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 More actions · Answer 13

: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: 2928 More actions · Answer 14

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