IDENTITY INSERT

Question

Post reply

IDENTITY INSERT

December 13, 2012 at 6:07 am

This was removed by the editor as SPAM

Viewing 15 posts - 16 through 30 (of 43 total)

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

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 1

Thanks for the clear question and explanation! Learned something about IDENTITY columns.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

Good question.

I am not sure why Lokesh chose to include a link to the SQL Server 2000 version of the documentation. Especially since the setup script uses SQL Server 2008 syntax to insert the first six rows into each table.

Here is a link to the most recent (SQL 2012) version of the IDENTITY INSERT article in Books Online: http://msdn.microsoft.com/en-us/library/ms188059.aspx

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Lokesh Vij SSChampion Points: 10836 More actions · Answer 3

Hugo Kornelis (12/13/2012)
Good question.
I am not sure why Lokesh chose to include a link to the SQL Server 2000 version of the documentation. Especially since the setup script uses SQL Server 2008 syntax to insert the first six rows into each table.
Here is a link to the most recent (SQL 2012) version of the IDENTITY INSERT article in Books Online: http://msdn.microsoft.com/en-us/library/ms188059.aspx

Thanks Hugo for pointing that out. I think the link has been copied mistakenly.

All glories to you for making the Qotd flawless as always.

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

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

thanks Hugo for pointing out that link thing 😛

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

Mike Hays SSCommitted Points: 1871 More actions · Answer 5

Mike Hays

SSCommitted

Points: 1871

December 13, 2012 at 6:51 am

#1568287

Good Question!!!

Sean Lange SSC Guru Points: 286590 More actions · Answer 6

Nice question Lokesh. Keep them coming.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

sqlserver8650 Ten Centuries Points: 1121 More actions · Answer 7

sqlserver8650

Ten Centuries

Points: 1121

December 13, 2012 at 7:19 am

#1568299

Nice Question

sestell1 SSChampion Points: 10230 More actions · Answer 8

Nice question, I'd completely forgotten about this limitation.

Primo Dang SSCrazy Points: 2643 More actions · Answer 9

Thank you for the good question, I had no idea about this behaviour.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Thanks for the 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