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