Sequence Indentity MSSQL Tutorial

INSERT Employee
(DepartmentID, Name, GroupName)
VALUES (17, 'Database Services', 'Information Technology')
SET IDENTITY_INSERT Employee OFF