Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to set up automatic growth of plastic data in sql server 2008, such as how to make this id grow automatically?
How to set up automatic growth of plastic data in sql server 2008, such as how to make this id grow automatically?
Create table user

(id int identification)

By default, it starts from 1 and the step size is 1, which can be modified.

For example:

Create table user

(id int identity( 1000,2))

This starts with 1000, adding 2 each time.