SQL Server manually inserts an ID column

If we insert a value in the ID column, for example:

Insert member (id, username) values (10, 'admin ')

The query analyzer will return an error message:

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

Write in the query analyzer as follows:

SET IDENTITY_Insert member ON insert member (id, username) values (1, 'admin') SET IDENTITY_Insert member OFF