sql 更新一列为行号

update u_menu

set issort=t1.rowId

from

(

 --select * from

 --(

  select cmenu_id,ROW_NUMBER() over(Order by cmenu_id) as rowId

  from u_menu

 ) as t1

 where t1.cmenu_id=u_menu.cmenu_id

--) as t