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