Day: April 1, 2008
-
Re-seeding the Identity Value
dbcc checkident ([table to re-seed], reseed, [value to set identity value at]) If you set the value to 0, the next inserted value will be 1
dbcc checkident ([table to re-seed], reseed, [value to set identity value at]) If you set the value to 0, the next inserted value will be 1