Xpode.com        Click here to Print this article.

Turning Off and On Identity Column in SQL Server

I have been moving over the data from one database to another. Issue came when data was entering in a table where idetity of a column was enable and I needed to enter the data as it is in identity column. I found solution. 

SET IDENTITY_INSERT tablename ON

insert statement comes here

SET IDENTITY_INSERT tablename OFF



http://
http://

Contributed by:
Rohit kakria
I am software developer, moderator of xpode.com

Resourse address on xpode.com
http://www.xpode.com/Print.aspx?Articleid=496

Click here to go on website