差异分析脚本

⑴ 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