Random thoughts and bits of Software Dev Knowledge
Collection of unedited thoughts and bits of knowledge I can't seem to remember
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)
‹
›
Home
View web version