How to compare all column records between two tables in SQL Server?

Asked Oct 30 '18 at 16:48

Active Oct 30 '18 at 17:25

Viewed 341 times

I want to compare two table records. and find which one is not matching. I am not looking for which record is not found in one table

Example: I have 2 databases called DBLive and DBLiveBackup, both with the same tables. One of the table is ProductDetails.

It has 15 columns; I want to compare the DBLive with DBLiveBackup database where records are not matching.

Update

I found this link. I almost looking for the same. But I cannot compare it one by one column like below code. because I have to compare whole database.

SELECT A.*, B.* 
FROM TABLEA A
INNER JOIN TABLEB B ON A.MSISDN = B.MSIDN
WHERE A.firstname != B.firstname 
   OR A.lastname != B.Lastname

edited Oct 30 '18 at 17:25

asked Oct 30 '18 at 16:48

Liam neesan

2,282
6
33
72

1

share sample data and expected output – Zaynul Abadin Tuhin Oct 30 '18 at 16:49
This has been answered lots of times on Stack Overflow. – dfundako Oct 30 '18 at 16:50
2

@dfundako If you gave a link to a duplicate, we could vote to close it as a duplicate. – Andrew Morton Oct 30 '18 at 16:52
@dfundako can you give where is the link. because i found only where is not exists in another table. But i am not looking for where records are not exists. I am looking for comparison of all fiels is not matching with one another – Liam neesan Oct 30 '18 at 16:52
@andrewMortan i agree – Liam neesan Oct 30 '18 at 16:52
1

Possible duplicate of [How to compare data between two table in different databases using Sql Server 2008?](https://stackoverflow.com/questions/7606175/how-to-compare-data-between-two-table-in-different-databases-using-sql-server-20) – Eric Brandt Oct 30 '18 at 17:08
4

Try using `EXCEPT` or `INTERSECT`, e.g. `SELECT * FROM [DatabaseA].[Schema].[Table] EXCEPT SELECT * FROM [DatabaseB].[Schema].[Table];` – Richard Hansell Oct 30 '18 at 17:13
@RichardHansell that would make a fine answer – S3S Oct 30 '18 at 18:10

How to compare all column records between two tables in SQL Server?

0 Answers0