sql server update 根据A表修改B表

update test..new set new='new1' where id=1
update test..new set new='new2' where id=2
update test..new set new='new3' where id=3
update test..new set new='new4' where id=4

以上用于恢复表数据

select * from test..new
select * from test..old

update test..new 
set new=(select old from test..old where id=1)
where id=1

update test..new 
set new=(select old from test..old where id=1)

update test..new  
set new=test..old.old 
from test..new  inner join test..old on test..new.id=test..old.id

--------------------以下是多列update

update test..new set new='new1' where id=1
update test..new set new='new2' where id=2
update test..new set new='test' where id=3
update test..new set new='new4' where id=4

update test..new set idd=null where id=1
update test..new set idd=null where id=2
update test..new set idd='testidd' where id=3
update test..new set idd=null where id=4

select * from test..new
select * from test..old

update test..new  
set new=test..old.old,
      idd=test..old.idd2
from test..new  inner join test..old on test..new.id=test..old.id

update test..new  
set new=t1.new,
    idd=t1.idd
from test..new  inner join (select * from test..new ) t1  on test..new.id =t1.id-2
where  test..new.id=1