How to write this sentence? Thank you

w2391392

sqlserver has two tables

Form A
code name status
1 a 01
2 b 02
3 c 03

Form B
code status
1 01
2 01
3 01

Now I want to modify the status of table A according to the status of table B, all are changed to 01, the associated field is code, how to write such a statement?

116657396

update A
set
    status = B.status
from
    B
where
    A.code = B.code

yflovefly

update a set a.status = b.status
from a, b
where a.code = b.code

hiqwolfzzh

update A set A.status = B.status where A.code = B.code

我是杀人狂

update tablea set status = b.status from tableb b where code = b.code

fanfan1980

create table A (code int, name char (1), status char (2))
insert A select 1, 'a', '01'
union all select 2, 'b', '02'
union all select 3, 'c', '03'

create table B (code int, status char (2))
insert B select 1, '01'
union all select 2, '01'
union all select 3, '01'

update A set A.status = B.status
from B
where A.code = B.code

select * from A

--result
code name status
----------- ---- ------
1 a 01
2 b 01
3 c 01

(3 row (s) affected)

hiqwolfzzh

update A
set A.status = B.status
from A, B
where A.code = B.code