Sequence Indentity MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Sequence Indentity
  4. SET IDENTITY_INSERT Employee ON
INSERT Employee
(DepartmentID, Name, GroupName)
VALUES (17, 'Database Services', 'Information Technology')
SET IDENTITY_INSERT Employee OFF