ms sql 更新表A中某列为表B中的值 select * from dbo.NT_areapin go select * from dbo.NT_dict_area update NT_areapin set AllNamePin='PengShui' from NT_areapin where AreaId='486' go update NT_dict_area set BriefNamePin = NT_areapin.BriefNamePin,AllNamePin = NT_areapin.AllNamePin from NT_dict_area,NT_areapin where NT_dict_area.Name = NT_areapin.Name; 本文来自都市家园,转载请标明出处:http://www.edongguan.com/blog/b178.aspx