When adding a row to the database table, this function is very useful when inserting a specific value for the self-incremented column, such as the table structure such as:
id | text
1 | a
2 | b
4 | d
The id column is the first column. If we want to insert 3 | c, if the self-increment column is not opened, it will definitely not be inserted. This function will be useful at this time.
Copy the codeThe code is as follows:
SET IDENTITY_INSERT [Recursive] ON
INSERT INTO [Recursive](id,text) VALUES(3,'c')
SET IDENTITY_INSERT [Recursive] OFF
INSERT INTO [Recursive](id,text) VALUES(3,'c')
SET IDENTITY_INSERT [Recursive] OFF
Usually we use this method when importing data, and I hope it will be helpful to everyone.