把某一字段更新为连续值的SQL
1 --从10001起，借用生成的行号，批量编号表记录 2 3 declare @start int = 10000; 4 5 update t1 set t1.newNo=t2.newNo 6 from student t1 7 join (select id, (row_number() over(order by id) + @start) newNo from student) t2 8 on t1.id=t2.id
1 --从10001起，借用生成的行号，批量编号表记录 2 3 declare @start int = 10000; 4 5 update t1 set t1.newNo=t2.newNo 6 from student t1 7 join (select id, (row_number() over(order by id) + @start) newNo from student) t2 8 on t1.id=t2.id
