SQL Server enables or disables auto-growth, SQL Server

SQL Server enables or disables auto-growth, SQL Server

When adding a row to a database table, you need to insert a specific value for the auto-increment column. This function is very useful. For example, the table structure is as follows:

Id | text

1 |

2 | B

4 | d

The id column is a self-contained column. If we want to insert 3 | c, if we do not open the auto-incrementing column, we cannot insert it. At this time, this function will be used.

Copy codeThe Code is as follows: SET IDENTITY_INSERT [Recursive] ON
 
Insert into [Recursive] (id, text) VALUES (3, 'C ')
 
SET IDENTITY_INSERT [Recursive] OFF

We usually use this method when importing data, hoping to help you.