update CCTDB..Area_Info
set ParentStr =b.ParentStr
from CCTDB..Area_Info a
inner join TempArea b
on a.AreaId = b.AreaId
set ParentStr =b.ParentStr
from CCTDB..Area_Info a
inner join TempArea b
on a.AreaId = b.AreaId
转载于:https://www.cnblogs.com/davidgu/archive/2012/08/10/2631289.html