SET IDENTITY_INSERT 允許明確的值插入資料表識別資料行中。語法 SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF }
CREATE TABLE Table1 ( AutoId int IDENTITY(1,1), Field1 nvarchar(30), Field2 nvarchar(30) ) SET IDENTITY_INSERT Table1 ON INSERT INTO Table1 SELECT 1,'R1C1','R1C2' SET IDENTITY_INSERT Table1 OFF
允許明確的值插入資料表識別資料行中。語法
SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF }
AutoId int IDENTITY(1,1),
Field1 nvarchar(30),
Field2 nvarchar(30)
)
SET IDENTITY_INSERT Table1 ON
INSERT INTO Table1 SELECT 1,'R1C1','R1C2'
SET IDENTITY_INSERT Table1 OFF