A 表和B表有一列相同，根据B表相同的一列更新A表对应的列

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 table 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
select * from dbo.table A order by column ID