To start autoincrement field from 1 in sqlserver.

To reset autoincrement value from 1 in sql server:


Step1: In query Designer write this Query

Syntax:
DBCC CHECKIDENT('DATABASENAME.DBO.TABLENAME',RESEED,number)

Eg:DBCC CHECKIDENT('DATABASENAME.DBO.TABLENAME',RESEED,0)

Step 2: Click on Execute.

After this query will executed our autoincremented field will start from 1.

If number=0 then the autoincrement value will start from 1. if number=101 then the autoincrement field will start from 102.

Thank You......