数据递归更新

--后一行的记录用前一行的更新if object_id('t') is not null drop table tgocreate table t(col1 varchar(20) primary key,col2 varchar(20),);insert into t values('1','1');insert into t values('2','2');insert into t values('a','3');insert into t values('c','4');insert into t values('e','5');insert into t values('f','6');--更新前select * from tupdate t2set col2=t1.col2from (select row_number() over(order by col1) row,col1,col2 from t) t1,(select row_number() over(order by col1) row,col1,col2 from t) t2where t1.row=t2.row-1--更新后select * from t;go