T-SQL备忘-表连接更新

1、update a inner join b on a.id=b.id set a.name=b.name where ...

 

2、update table1 set a.name = b.name from table1 a inner join table2 b on a.id =b.id where...