重新排序字段

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;