sql server 更新自增长id

--将自增长重新设置
dbcc checkident('table1',reseed,1)
--将数据倒入临时表
select  name,pwd  into   #   from table1 order   by   id;
--清空源表,它同时会重置标识列
--truncate   table   student
delete from table1;
--将数据导回源表
insert into table1 select * from #;
--删除临时表  
drop table #;