不同数据库USE DB1 GO SELECT * FROM dbo.tb EXCEPT SELECT * FROM DB2..tbUSE DB1 GO SELECT * FROM tb WHERE NOT EXISTS (SELECT * FROM DB2..tb)
-- 假如a表有字段. id,a,b,c SELECT id,a,b,c,MAX(db) db,COUNT(1) ct FROM ( SELECT *,'db1' db FROM db1.dbo.a UNION ALL SELECT *,'db2' db FROM db2.dbo.a ) t GROUP BY id,a,b,c HAVING COUNT(1)=1
所有字段 不是单个字段 因为我两个库经常更新时漏更新数据 导致两边不一致哦 那用上面的就行的,except就可以
GO
SELECT * FROM dbo.tb
EXCEPT
SELECT * FROM DB2..tbUSE DB1
GO
SELECT * FROM tb WHERE NOT EXISTS (SELECT * FROM DB2..tb)
SELECT *,'db1' db FROM db1.dbo.a
UNION ALL
SELECT *,'db2' db FROM db2.dbo.a
) t
GROUP BY id,a,b,c
HAVING COUNT(1)=1