sql server management studio set identity_insert code example

Example 1: identity insert on sql server

SET IDENTITY_INSERT sometableWithIdentity ON

INSERT sometableWithIdentity (IdentityColumn, col2, col3, ...)
VALUES (AnIdentityValue, col2value, col3value, ...)

SET IDENTITY_INSERT sometableWithIdentity OFF

Example 2: identity_insert is set to off

SET IDENTITY_INSERT tbl_content ON