select identity(int,1,1) as sn,field1 into #t from t1; update #t set field1=sn;
create table #t(id int, ff varchar(10))insert into #t(ff) select 'a' insert into #t(ff) select 'b' insert into #t(ff) select 'c' declare @i int set @i=0update #t set id=@i,@i=@i+1select * from #t drop table #t
delete from t1; insert into t1 select field1 from #t;
update #t set field1=sn;
create table #t(id int, ff varchar(10))insert into #t(ff) select 'a'
insert into #t(ff) select 'b'
insert into #t(ff) select 'c'
declare @i int
set @i=0update #t set id=@i,@i=@i+1select * from #t
drop table #t
insert into t1 select field1 from #t;