语法:
SET IDENTITY_Insert [TableName] ON
示例:
SET IDENTITY_INSERT dbo.table1 ON INSERT INTO dbo.table1(id,username) values(1,'admin') SET IDENTITY_Insert dbo.table1 OFF -- 可省略,会话完毕后,当前开关由系统自动关闭
语法:
示例:
SET IDENTITY_INSERT dbo.table1 ON INSERT INTO dbo.table1(id,username) values(1,'admin') SET IDENTITY_Insert dbo.table1 OFF -- 可省略,会话完毕后,当前开关由系统自动关闭