sql when IDENTITY_INSERT is set to OFF code example
Example 1: identity_insert is set to off
SET IDENTITY_INSERT tbl_content ONExample 2: set identity_insert off
SET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }SET IDENTITY_INSERT tbl_content ONSET IDENTITY_INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }