[DB] SET IDENTITY_INSERT (Transact-SQL)

SET IDENTITY_INSERT (Transact-SQL)

Syntax

SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF }

Arguments

database_name

Is the name of the database in which the specified table resides.

schema_name

Is the name of the schema to which the table belongs.

table

Is the name of a table with an identity column.

https://msdn.microsoft.com/en-us/library/ms188059.aspx