Pages

Apr 16, 2012

How to set Identity column value start from certain value + SQL

Below is the SQL query to get the  to set Identity column value start from certain value

DBCC CHECKIDENT ( 'TestDB.dbo.TestTable',RESEED, 1000000)