wtorek, 30 sierpnia 2011
Reseting autoimcrement seed in MSSQL
I was working on importing data into MSSQL database recently and I needed to reimport data to some table.
Because the primary key of the table was setup as identity column after removing previously inserted rows I needed to reset Identity Seed.
Here's the way how you can accomplish that:
DBCC CHECKIDENT ('dbo.MyTable', RESEED, 1)
Subskrybuj:
Komentarze do posta (Atom)
Brak komentarzy:
Prześlij komentarz