把某一字段更新为连续值的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

 

转载于:https://www.cnblogs.com/eval/p/5355689.html