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