sql server的小问题
原先在表中删除了的一条数据，现在要重新添加回那张表中。可是主键不是连续的了，怎样通过sql语句来设置主键跟删除之前那样使得主键ID连续呢？先谢过各位啦！ SQL?Server
[解决办法]

create table lee
( id int identity(1,1) not null,
  name varchar(10)
  constraint pk_lee primary key(id)  
)

insert into lee(name)
 select 'aa' union all
 select 'bb' union all
 select 'cc' union all
 select 'dd' union all
 select 'ee'

select id,name from lee

/*
id          name
----------- ----------
1           aa
2           bb
3           cc
4           dd
5           ee

(5 row(s) affected)
*/

--原先在表中删除了的一条数据
delete from lee where id=3
 
--现在要重新添加回那张表中
insert into lee(name) select 'cc'

--可是主键不是连续的了
select id,name from lee

/*
id          name
----------- ----------
1           aa
2           bb
4           dd
5           ee
6           cc

(5 row(s) affected)
*/

--主键跟删除之前那样使得主键ID连续
delete from lee where id=6  --> 删除测试记录

set identity_insert lee on

insert into lee(id,name) select 3,'cc'

set identity_insert lee off


select id,name from lee

/*
id          name
----------- ----------
1           aa
2           bb
3           cc
4           dd
5           ee

(5 row(s) affected)
*/