Shulou(Shulou.com)06/01 Report--

Open the database table to be set, and click the field to be set, such as id, and the column properties list properties of id will appear below. You can set the field self-increment by setting the properties of "identity specification". From the following figure, whether the value of "yes identification" is not self-increasing field means that id is not a self-increasing field that can set the field of ID field to be self-increasing, such as the int,bigint type, while the varchar type is not self-increasing. For example, when you look at the column properties of name, you can see whether the "Yes identity" is unchangeable. Click "identity Specification", after expansion, click "Yes identity" and the drop-down list button will appear. You can double-click the settings or select from the drop-down list. After setting the value of "Yes identity" to "Yes", you can see that the following properties write the value by default to set the identity increment and identity seed. Identification increment is the value that the field automatically increases each time, such as 1, and the field increases by 1 each time. If the identification seed is the initial value of the field, such as 1, then the field value of the first record is 1. After the setting is completed, don't forget to click "Save"

END

Matters needing attention

Pay attention to the type of field when setting self-increment field. Not all field types can set self-increment field.

Tables with self-increasing primary keys in SQLServer usually cannot be inserted with ID values directly, but can be inserted in the following ways.

1. SQLServer self-adding primary key creation syntax:

Identity (seed, increment)

Among them

Seed starting value

Increment increment

Example:

Create table student (id int identity (1), name varchar (100)

two。 Specifies that data is inserted from the increment of the primary key column value (SQL Server 2000)

Execute the following statement first

SET IDENTITY_INSERT [database. [owner. ]] {table} ON

Then execute the insert statement

Finally, execute the following statement

SET IDENTITY_INSERT [database. [owner. ]] {table} OFF

Example:

The table is defined as follows

Create table student (id int identity (1), name varchar (100)

Insert data

Set IDENTITY_INSERT student ONinsert into student (id,name) values (1); insert into student (id,name) values (2); set IDENTITY_INSERT student OFF

Summary

The above is a simple way to set up the ID field when setting up the sql server table introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.