SQL Set IDENTITY_INSERT usage

Syntax
SET IDENTITY_INSERT [database. [owner.] {table} {ON | OFF}

Parameters
Database is the name of the database where the specified table resides.

Owner
Is the name of the table owner.

Table
Is the name of the table containing the ID column.

For example, insert 1 million records into the database.
Copy codeThe Code is as follows:
Set identity_insert sosuo8database on
Declare @ count int
Set @ count = 1
While @ count <= 1000000
Begin
Insert into sosuo8database (id, userName, userPWD, userEmail) values (@ count, 'ahuina', 'ahuina', 'sosuo8. com') set @ count = @ count + 1
End
Set identity_insert sosuo8database off