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?

Featured Posts
Recent Posts
Archive
Search By Tags
No tags yet.
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square