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)

Brak komentarzy: