sql server 重新序号

update tmpTable set xuhao = rownum from(
    select  xuhao,ROW_NUMBER() over(order by CAST( xuhao as int)) rownum from zbactivityjoin
) tmpTable