update tb_template
set priority_num=i.rn
from( select temp_id tempid, rn=ROW_NUMBER()over(order by priority_num )
from tb_template)i
where i.tempid=temp_id;
重新排序字段
最新推荐文章于 2025-01-20 19:20:54 发布
update tb_template
set priority_num=i.rn
from( select temp_id tempid, rn=ROW_NUMBER()over(order by priority_num )
from tb_template)i
where i.tempid=temp_id;

被折叠的 条评论
为什么被折叠?