学步园

ms sql 更新表A中某列为表B中的值

select *<br /> from dbo.NT_areapin<br /> go<br /> select *<br /> from dbo.NT_dict_area</p> <p>update NT_areapin<br /> set AllNamePin='PengShui'<br /> from NT_areapin<br /> where AreaId='486'<br /> go<br /> update NT_dict_area<br /> set BriefNamePin = NT_areapin.BriefNamePin,AllNamePin = NT_areapin.AllNamePin<br /> from NT_dict_area,NT_areapin<br /> where NT_dict_area.Name = NT_areapin.Name;<br />

本文来自都市家园，转载请标明出处：http://www.edongguan.com/blog/b178.aspx