致那向往的远方

摘要： 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... 阅读全文