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
Solutions to common programming problems in Java, C#, .Net, Python, SQL, Excel/VBA and other languages.
Post a Comment