SET IDENTITY

• Allows explicit values to be inserted into the column with the identity property.

SET IDENTITY_INSERT SomeTable OFF
GO
 
INSERT INTO SomeTable(IdentityColumn) VALUES(1)
 
GO
SET IDENTITY_INSERT SomeTable  OFF