SQL Server turns on or off self-growth _mssql2008

When you add a row to a database table, this function is useful when inserting a specific value for the self-added column, such as the table structure:

ID | Text

1 | A

2 | B

4 | D

Where the ID column is from the previous column, if we want to insert 3 | C, if you do not open the self-add column, it must be plugged in, this time with this function will be useful

Copy Code code as follows:

SET Identity_insert [Recursive] on

INSERT into [recursive] (Id,text) VALUES (3, ' C ')

SET Identity_insert [recursive] off

Usually we use this method when we import the data, and we hope it will help us.