Skip to content
Home » sql server identity insert

sql server identity insert

SQL SERVER SET IDENTITY_INSERT

SQL Server IDENTITY_INSERT allows explicit values to be inserted into the identity column of a table.  

The IDENTITY_INSERT statement must be set ON to insert explicit value for identity column. By default IDENTITY_INSERT is OFF.

 3,843 total views,  6 views today