SET IDENTITY_INSERT [dbo].[tblName] ON
insert into [dbo].[tblName]([column1],[column2],[column3]) values(10001,101,104)
insert into [dbo].[tblName]([column1],[column2],[column3]) values(20001,101,141)
SET IDENTITY_INSERT [dbo].[tblName] OFF
需要注意: 插入操作需要明确指定列名。