SQL用于更新ID为顺序ID(用于删除了几条数据导致id不连续)

UPDATE tab1022zhm SET ID =
FROM (SELECT ROW_NUMBER() OVER (ORDER BY id) ROW,comName FROM dbo.tab1022zhm) a WHERE tab1022zhm.comName=a.comName