What Changed? Using T-SQL to Find Differences Between Tables
- Martin Perez
- Aug 31, 2017
- 1 min read
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
Comments