sqlserver delete 删除兩個表的差集

merge t_kp t using (select id from t_kp except select kid from T_KPItem)s on t.id=s.id when matched then delete;      

merge , except 是sql 2008 版本以上才有的