求SqL语句，根据另一表批量更改数据
如下有两表
A B
ID Location ID NewLocation
1 a 2 d
2 b 3 d
3 c 4 e
4 d 6 e
5 e
6 f
按B中的数据更改A表的Location字段，让与B表中ID相对应的A表的Location换成B表中的NewLocation
更新后A表变为：
A
ID Location
1 a
2 d
3 d
4 e
5 e
6 e
[解决办法]
update a
set location = b.newlocation
from a,b
where a.id = b.id
[解决办法]
update A set A.Location=B.NewLocation FROM A inner join B on A.ID=B.ID
[解决办法]
if object_id( 'pubs..A ') is not null
drop table A
go
create table A(ID int,Location varchar(1))
insert into A(ID,Location) values(1, 'a ')
insert into A(ID,Location) values(2, 'b ')
insert into A(ID,Location) values(3, 'c ')
insert into A(ID,Location) values(4, 'd ')
insert into A(ID,Location) values(5, 'e ')
insert into A(ID,Location) values(6, 'f ')
go
if object_id( 'pubs..B ') is not null
drop table B
go
create table B(ID int,newLocation varchar(1))
insert into B(ID,newLocation) values(2, 'd ')
insert into B(ID,newLocation) values(3, 'd ')
insert into B(ID,newLocation) values(4, 'e ')
insert into B(ID,newLocation) values(6, 'e ')
update a
set location = b.newlocation
from a,b
where a.id = b.id
select * from A
drop table A,B
/*
ID Location
----------- --------
1 a
2 d
3 d
4 e
5 e
6 e
（所影响的行数为 6 行）
*/
[解决办法]
update a set location=newlocation from b where a.id=b.id
[解决办法]
UPDATE a
SET location = b.newlocation
FROM a,b
WHERE a.id = b.id
