Here is a sample approach.
I have created two tables with identical columns and inserted some data in both the tables. Then i have queried the tables to retrieve rows which are not same.
CREATE TABLE #Table1
(
ID INT PRIMARY KEY,
[Name] VARCHAR(50),
Email VARCHAR(50)
)
CREATE TABLE #Table2
(
ID INT PRIMARY KEY,
[Name] VARCHAR(50),
Email VARCHAR(50)
)
INSERT INTO #Table1
SELECT 1, 'XYZ', 'XYZ@XYZ.com' UNION ALL
SELECT 2, 'XYZ 1', 'XYZ1@XYZ.com' UNION ALL
SELECT 3, 'XYZ 2', 'XYZ2@XYZ.com' UNION ALL
SELECT 4, 'XYZ 3', 'XYZ3@XYZ.com' UNION ALL
SELECT 5, 'XYZ 4', 'XYZ4@XYZ.com'
INSERT INTO #Table2
SELECT 1, 'XYZ', 'XYZ@XYZ.com' UNION ALL
SELECT 2, 'XYZ 1', 'XYZ13@XYZ.com' UNION ALL
SELECT 3, 'XYZ 2', 'XYZ2@XYZ.com' UNION ALL
SELECT 4, 'XYZ 3', 'XYZ3@XYZ.com' UNION ALL
SELECT 5, 'XYZ 45', 'XYZ4@XYZ.com'
SELECT * FROM #Table1 T1
LEFT JOIN #Table2 T2 ON T1.ID = T2.ID
WHERE T1.[Name] <> T2.[Name] OR T1.Email <> T2.Email
DROP TABLE #Table1
DROP TABLE #Table2
Hope this helps.