Search This Blog

Friday, March 4, 2011

INSERT IDENTITY syntax

Piece of SQL knowledge that I can't seem to keep in my brain...




SET IDENTITY_INSERT table ON

SET IDENTITY_INSERT table OFF


Now to Reseed the Identity column in a table


DBCC CHECKIDENT (table, reseed, newseedvalue)