Set auto-increment fields in SQL Server

What is the auto-increment field in SQL Server (like the serial number sequence in Oracle? How to use it?

1. Create Table Name (
Field name [int] identity (1, 1) not null,
...
)

2. in SQL Server, All Integer columns can be defined as self-incrementing columns, which are called "identifiers ",
It sets "id seed" and "id increment" to implement the function.
Example:

Column type identity seed identity Increment
--------------------------------
Test tinyint √ 1 1

When you insert a row, the value is automatically assigned from 1. (1, 2, 3, 4 ...... 255)

Method:
1. Select a table;
2. Right-click the mouse and design it;
3. Selected columns (integer type)
4. Set the ID to "yes" (No by default), Id seed, and Id increment (generally 1 ).

Note: SQL Server 2000 is easier to use and provides a full Chinese version of the interface for clearer classification.
**************************************** *********************************
To implement auto-increment fields in Oracle, you can use create sequence Sid minvalue 1 maxvalue 10000000; To implement auto-increment of SID columns.