Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)delv
published in(发表于) 2013/12/30 4:33:24
ms，sql，更新表A中某列为表B中的值_mssql学习_编程技术

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;


赞

If you have any requirements, please contact webmaster。(如果有什么要求，请联系站长)




QQ:154298438
QQ:417480759