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

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;