Monday, 16 March 2009

How to quickly compare 2 tables in SQL Server

This is the fastest way to compare 2 tables in SQL Server. Generate hash for both tables and see if it's the same.

SELECT checksum_agg(checksum (*)) FROM table1

No comments:

Post a Comment