利用identity实现

create table testautoid
(
  id int identity(1,1),
  sname varchar(100)
)
go
insert into testautoid(sname)
select 'a'
go
select * from testautoid

id sname
1 a