数据更新sql server

select * from Table_1 ;
select * from Table_2;
select  b.name,b.salary from  Table_1 a inner join Table_2 b on a.id=b.id;

--更新一条数据
update Table_1   set salary=(select salary from Table_2 where id='1') where id='1';

--A表数据更新到B表(*更新多条)
update Table_1 SET Table_1.salary = Table_2.salary ,Table_1.name=Table_2.name FROM Table_1 ,Table_2 WHERE  Table_1.id = Table_2.id