delete table A
update table A set column A=b.column A from table A a
inner join table B b on a.column C =b.column C
update table A set column B=b.column B from tabl
e A a
inner join table B b on a.column C =b.column C
update table A set column D =b.column D from table A a
inner join table B b on a.column C =b.column C
selec
t * from dbo.table A order by column ID