update kaifaqu
update kaifaqu s set id = t.rownum
from (select ROW_NUMBER() OVER() as rownum,name from kaifaqu) as t
where s.name = t.name
update kaifaqu s set id = t.rownum
from (select ROW_NUMBER() OVER() as rownum,name from kaifaqu) as t
where s.name = t.name