EXCEPT最方便了(SELECT * FROM TB1 EXCEPT SELECT * FROM TB2) UNION ALL (SELECT * FROM TB2 EXCEPT SELECT * FROM TB1) 所有不同的行都出来了
SELECT * ,'T1多出数据' AS Tab FROM (SELECT * FROM T1 EXCEPT SELECT * FROM T2 )a UNION ALLSELECT * ,'T2多出数据' AS Tab FROM ( SELECT * FROM T2 EXCEPT SELECT * FROM T1 ) AS b
NOT EXISTSCHECKSUM(*)都可以。
(SELECT * FROM TB1 EXCEPT SELECT * FROM TB2) UNION ALL (SELECT * FROM TB2 EXCEPT SELECT * FROM TB1)
EXCEPT
SELECT * FROM TB2)
UNION ALL
(SELECT * FROM TB2
EXCEPT
SELECT * FROM TB1)
所有不同的行都出来了
FROM
(SELECT * FROM T1
EXCEPT
SELECT * FROM T2
)a
UNION ALLSELECT * ,'T2多出数据' AS Tab
FROM (
SELECT * FROM T2
EXCEPT
SELECT * FROM T1
) AS b
EXCEPT
SELECT * FROM TB2)
UNION ALL
(SELECT * FROM TB2
EXCEPT
SELECT * FROM TB1)