sql server2000中实现一个字段的自增长

CREATE TABLE pln_project_model (
        model_id int not null identity(1,1) primary key,
        model_name varchar(20)  NULL ,
)
insert into pln_project_model ( model_name )values ('项目概述') 

insert into pln_project_model ( model_name )values ('支付管理') 

insert into pln_project_model ( model_name )values ('项目记录') 

 

 

select * from pln_project_model

 

结果：

------------------

model_id      model_name

1                   项目概述

2                   支付管理

3                   项目记录

-----------------