Loading

Code to compare 2 database tables and count the difference?

Mike kiser

Hey All,

Does anyone hava any code to compare to like database tables and do something with the differences? I have to determine if any of the fields have changed in a SQL DB Table and if so then write to a Azure Blob.

Thanks so much!
Mike

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
You have multiple set Operators like Intersect,Except etc
Intersect:- Gives what is common in two tables.
Except :- returns what is in table 1 but not in table 2.
SELECT CustId, CustName, CustAddress, CustPhone FROM Original
EXCEPT
SELECT CustId, CustName, CustAddress, CustPhone FROM Revised