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
Leave a Reply