使用 Join进行 两表或多表 联表更新 Update方法:
两表更新:UPDATE table_1 SET table_1.colname = t2.colname from table_1 t1 left join table_2 t2 on t1.id = t2.id where t1.id>5;
多表更新:Update
a
set
a.Manage_FunctID=b.Manage_FunctID
From
Manage_PageUrl a
Left
join
Manage_ButtonBar b
on
a.Manage_PageUrlID=b.Manage_PageUrlID
Left
join
Manage_Funct c
on
b.Manage_FunctID=c.Manage_FunctID