1SET IDENTITY_INSERT sometableWithIdentity ON
2
3INSERT sometableWithIdentity (IdentityColumn, col2, col3, ...)
4VALUES (AnIdentityValue, col2value, col3value, ...)
5
6SET IDENTITY_INSERT sometableWithIdentity OFF
1
2SET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }
3