If we insert a value in the ID column, for example:
Insert member (id, username) values (10, 'admin ')
Reference Content Server: Message 544, level 16, status 1, Row 1 when IDENTITY_Insert is set to OFF, explicit values cannot be inserted into the identification column in The 'member' table.
In some cases, we need to manually insert the value of the ID column. For example, after deleting some records, the ID column is not consecutive, and we want to complete it. We can use a switch to turn our desires into reality:
SET IDENTITY_Insert [TableName] ON
SET IDENTITY_Insert member ON insert member (id, username) values (1, 'admin') SET IDENTITY_Insert member OFF