SQL SERVER 更新某个表的某个字段的值为自动编号的SQL

更新颜色编码为4位的不重复自动编号：

update a set a.No=b.Nub from M_Color a,
(SELECT ColorID, RIGHT('0000' + CAST(ROW_NUMBER() OVER (ORDER BY ColorID) AS VARCHAR(10)), 4) as Nub FROM M_Color) b
where a.ColorID=b.ColorID