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?