select identity(int,1,1) as newvalue,* into #temp from yourtable
truncate yourtable
insert yourtable
select newvalue,col2,col3.... from #temp
truncate yourtable
insert yourtable
select newvalue,col2,col3.... from #temp
alter table 表 drop 你要修改的字段 ...........
好啦,结