sql server 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