ms sql 更新表A中某列為表B中的值 view plaincopy to clipboardPRint? 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;
