Xpode.com        Click here to Print this article.

If there is a table with identity key column, can we insert value in that column explicitly? If yes then how

SET IDENTITY_INSERT Test ON
Insert Into Test(Id, Name) Values (1, ‘Amit’)
SET IDENTITY_INSERT Test OFF







Contributed by:
Guest
Guest user is that user who have done some activity on website without login. Activity contains commenting on any article, uploading an image on website etc.

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

Click here to go on website