G Tech
IT stuff that is easy to forget or just don't want to remember.
Monday, September 10, 2007
MS SQL - Reseting IDENTITY value
If you want to reset your identity field to a certain number, use the following statement:
DBCC CHECKIDENT ('tablename', RESEED, new identity value)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment