SQLServer, only when the column list is used and IDENTITY_INSERT is ON, you can specify an explicit value for the ID column in table xx, sqlserveridentity

SQLServer, only when the column list is used and IDENTITY_INSERT is ON, you can specify an explicit value for the ID column in table xx, sqlserveridentity

Scenario: if the primary key of the table or one of the columns uses IDENTITY () for auto-increment, but you want to manually specify a value for this column, use the following solution:

Set identity_insert table name ON

Use this command to set the auto-incrementing column of the Table to ON

Then use:

SELECT 3, 0, 'badand', 141,0, 2, '20180101', '09 24 133 PM ', '20180101', '09 24 2008 PM', 0, 'null'

Insert data (Select is used, and Insert into cannot be used ).

After the insertion is complete, set the column to OFF.

Set identity_insert [agent_ctm_shopgroup_tbl] OFF