SQL Server batch rules modify field values

Recently there is a task, the database of more than 3,000 existing data from 800000 to start numbering, each increment of 1, so there are the following three solutions:

1, directly in the database manually one plus (you happy is good)

2. Add a database field, such as number, set the numbers field as the identity column, set the seed and increment, and then set the field to be non-identity column and modify the field type (int data type only) after saving the table automatically generated value.

3. Using Database statements (recommended)

DECLARE @number INT--Defines a variable @number
Set @number = 799999--Sets the value of the variable to the seed value minus 1
Update table name set field name [email protected],@[email protected]+1--Modify field values, set rules as needed

SQL Server batch rules modify field values