SQL Server:Find table Differences

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