DBCC CHECKIDENT('TABLE_NAME', RESEED, 1)
参考连接:https://blog.csdn.net/leiyong0326/article/details/39925937
不允许显式插入:
set identity_insert table_name ON--打开
--插入值
insert into table_name(colu1,colu2,colu3)
values(values1,values2,values3)
set identity_insert table_name OFF--关闭