update Countrys set (    Abbreviation_cn,    Abbreviation_en,    Two_code,Three_code,    Number_code)=     (select  [cn_name],            [en_name],            [two_code],            [free_code],            convert(int,number_code) as [number_code]     from  Country.dbo.worlds a where a.cn_name=Countrys.Abbreviation_cn)

 

UPDATE Countrys   SET  Abbreviation_cn= Country.dbo.worlds.cn_name,                Abbreviation_en=Country.dbo.worlds.en_name,                Two_code=Country.dbo.worlds.two_code,Three_code=Country.dbo.worlds.free_code                   FROM Countrys,Country.dbo.worlds WHERE Countrys.chinese_name+' '+Countrys.english_name = Country.dbo.worlds.all_name