SQL 标识列起始种子重设

 

DBCC   CheckIdent (TableName,   RESEED,   0)

 

 

SET IDENTITY_INSERT  TableName On

insert into TableName(标识列)  values(1)

SET IDENTITY_INSERT  TableName Off