34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM 业务表 A, 业务表记录B
WHERE A.ID = B.ID
....
AND (A.a <>B.a
OR A.b <>B.b
OR A.c <>B.c
OR A.d <>B.d
OR A.e <>B.e
OR A.f <>B.f
...)
--1
SELECT *
FROM #ta AS a ,
#tb AS b
WHERE a.id = b.id
AND NOT (
a.a = b.a
AND a.b = b.b
AND a.c = b.c
AND a.b = b.d
AND a.e = b.e
)
--2
SELECT *
FROM #ta AS a ,
#tb AS b
WHERE a.id = b.id
AND NOT EXISTS ( SELECT 1
FROM #tb AS c
WHERE a.a = c.a
AND a.b = c.b
AND a.c = c.c
AND a.b = c.d
AND a.e = c.e
AND a.id = c.id )
AND (A.a+A.b+A.c+A.d+Q.d+Q.e+Q.f)<>(B.a+B.b+B.c+B.d+B.d+B.e+B.f)