ms sql 更新表A中某列为表B中的值_mssql学习_编程技术-你的首页-uuhomepage.comms 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;