格式
SET IDENTITY_INSERT 表名 ON
INSERT INTO table(属性名称)VALUES(添加的内容)
SET IDENTITY_INSERT 表名 OFF
举例
SET IDENTITY_INSERT test1 ON
INSERT INTO test1(id,content) VALUES(1,'测试数据')
SET IDENTITY_INSERT test1 OFF
SET IDENTITY_INSERT 表名 ON
INSERT INTO table(属性名称)VALUES(添加的内容)
SET IDENTITY_INSERT 表名 OFF
SET IDENTITY_INSERT test1 ON
INSERT INTO test1(id,content) VALUES(1,'测试数据')
SET IDENTITY_INSERT test1 OFF