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

posted on 2022-03-02 12:01  历历往事如在昨日  阅读(26)  评论(0)    收藏  举报

导航