SQL Server, you can specify an explicit value for an identity column in table xx only if a column list is used and IDENTITY_INSERT is on

Scenario: If the primary key of this table or one of the columns uses IDENTITY (total) self-growth, 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 self-increment column of the table to On

Then use:

SELECT 3, 0, ' Adolph ', 141,0,2, ' 133 ', '  3:23pm ', ' 133 ', '  3:23pm ', 0, ' NULL '

, insert the data (the way you use SELECT, you cannot insert into).

When the insert is complete, set the column to OFF

SET IDENTITY_INSERT [AGENT_CTM_SHOPGROUP_TBL] OFF

SQL Server, you can specify an explicit value for an identity column in table xx only if a column list is used and IDENTITY_INSERT is on