去掉自增然后执行T-SQL语句

SET IDENTITY_INSERT [TableName] ON ;
--T-SQL(INSERT)
SET IDENTITY_INSERT [TableName] OFF ;