blah blah blah is here! blah blah » Close

1
votes
1 answers

Reseeding a table in sql server with the identity value of 2

I want to purge all rows in a table except for the row with ID = 1. I then want to reseed the table so that the next row that is inserted will have the ID value of 2. I remember that you can reseed the identity column, how can I do th ...

Feedback