Consider two tables TblA and TblB having similar schema
1. Find all records from TblA table that are not in TblB table
SELECT
* FROM dbo.TblA
EXCEPT
SELECT
* FROM dbo.TblB
2. Find all records from TblB table that are not in TblA table
SELECT
* FROM dbo.TblB
EXCEPT
SELECT
* FROM dbo.TblA
3. To get above Differences together run below
SELECT
‘TableName_TblA’ AS
TableName, * FROM
(
SELECT
* FROM dbo.TblA
EXCEPT
SELECT
* FROM dbo.TblB
)
X
UNION ALL
SELECT
‘TableName_TblB’ AS
TableName, * FROM
(
SELECT
* FROM dbo.TblB
EXCEPT
SELECT
*FROM dbo.TblA
)
X
Leave a Reply