¼òµ¥sqlÓï¾ä - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏÂ
Á½Õűí
create table A
(
  idcard varchar(20),
  aa varchar(20),
  bb varchar(30)
)


create table B
(
  idcard varchar(20),
  aa varchar(20),
  bb varchar(30)£¬
  cc varchar(30)
)

ÏÖÔÚ¸ù¾Ýidcard Ïàͬ£¬ÓÃA±íÖÐaa,bb×ֶθüÐÂB±íÖÐaa£¬bb×Ö¶Î

лл°ïæ

---

SQL code:
update b set b.aa=a.aa,b.bb=a.bb
from b
join a on a.idcard=b.idcard

---

SQL code:
update b set b.aa=a.aa,b.bb=a.bb
from a where a.idcard=b.idcard

---

update b set b.aa=a.aa,b.bb=a.bb from a,b where a.idcard=b.idcard

---

SQL code:

create table A
(
idcard varchar(20),
aa varchar(20),
bb varchar(30)
)
insert into A
select 1,'333','333333'

create table B
(
idcard varchar(20),
aa varchar(20),
bb varchar(30),
cc varchar(30)
)
insert into B
select 1,'222','2','22'

update b set
aa=(select aa from a where idcard =b.idcard)
,bb=(select bb from a where idcard =b.idcard)
from b


select *from B

idcard