What Changed? Using T-SQL to Find Differences Between Tables
Do you need to compare the data between tables to find what is missing? Or do you need to watch for when data changes in a table? There are many methods and tools to use. Here, we'll cover a range of T-SQL code and database settings, from basic to complex, to find these differences and changes: Brute force - write it all out Not Exists Left Outer Join Intersect Except Row Version Change Tracking Change Data Capture What Changed?