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
1SET IDENTITY_INSERT sometableWithIdentity ON
2
3INSERT sometableWithIdentity (IdentityColumn, col2, col3, ...)
4VALUES (AnIdentityValue, col2value, col3value, ...)
5
6SET IDENTITY_INSERT sometableWithIdentity OFF
77
8identity_insert is set to offSQL By Super Snail on Oct 6 2020
9SET IDENTITY_INSERT tbl_content ON
101
11set identity_insert offSQL By Bams999 on Jan 27 2021
12
13SET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }