Random thoughts and bits of Software Dev Knowledge
Collection of unedited thoughts and bits of knowledge I can't seem to remember
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)
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)