with CTE as
(
select *,rn=ROW_NUMBER() OVER(ORDER BY id desc)
from #_temp_1 where id > 0
)
update CTE set rowid_temp= rn
Sql server对表中数据进行排序,并将序号更新至列
最新推荐文章于 2022-03-07 15:42:35 发布
with CTE as
(
select *,rn=ROW_NUMBER() OVER(ORDER BY id desc)
from #_temp_1 where id > 0
)
update CTE set rowid_temp= rn