SET IDENTITY_INSERT TABLENAME ON --关闭
INSERT INTO TABLENAME(IDENTYTY_ID,...) VALUES(...)
INSERT INTO TABLENAME(IDENTYTY_ID,...) VALUES(...)
INSERT INTO TABLENAME(IDENTYTY_ID,...) VALUES(...)
SET IDENTITY_INSERT test OFF --开启
SET IDENTITY_INSERT TABLENAME ON --关闭
INSERT INTO TABLENAME(IDENTYTY_ID,...) VALUES(...)
INSERT INTO TABLENAME(IDENTYTY_ID,...) VALUES(...)
INSERT INTO TABLENAME(IDENTYTY_ID,...) VALUES(...)
SET IDENTITY_INSERT test OFF --开启