SET IDENTITY_INSERT Employee ON : IDENTITY_INSERT « Sequence Indentity « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Sequence Indentity
  3. IDENTITY_INSERT
INSERT Employee
(DepartmentID, Name, GroupName)
VALUES (17, 'Database Services', 'Information Technology')

SET IDENTITY_INSERT Employee OFF








15.3.IDENTITY_INSERT
15.3.1.SET IDENTITY_INSERT Employee ON
15.3.2.Using the IDENTITY_INSERT Session Option