SQL Server 2008 How to add a self-added column to implement the self-added serial number _mssql2008

In the "Computer room toll system", some tables need to add their own columns, add a new record automatically add a serial number. Here are two ways to add:

One, through T-SQL code.

Copy Code code as follows:

ALTER TABLE name add column name int IDENTITY (1,1) not NULL

Here we use the Identity keyword: indentity (a,b), a B are all positive integers, A is the start, B is the step, indentity (1,1) on behalf of 1, each increase 1

Second, through Enterprise Manager

Open Object Explorer, create a new table, as shown below

Inserts a column, sets the column properties, identifies the increment as the step, identifies the seed as the starting number, and the following figure

The beginner, the improper place please criticize correct!