sql server 中多条数据找出数据表中不存在的数据
SELECT VALUE FROM ( VALUES ( '采购' ), ( '1' ), ( '22' ) ) AS input_values ( VALUE ) WHERE VALUE NOT IN ( SELECT cczz FROM cizu );
SELECT VALUE FROM ( VALUES ( '采购' ), ( '1' ), ( '22' ) ) AS input_values ( VALUE ) WHERE VALUE NOT IN ( SELECT cczz FROM cizu );