差異分析腳本

⑴ SQLServer 用腳本比較兩表差異。正確答案追加分。

（1）select * from A表 where column_1 not in (select column_1 from B表)
（2）select case when b.column_2 <> a.column_2 then b.column else null end as column_2,
後面的欄位 from 表B as b
left join 表A a
on a.column_1=b.column_1