top of page

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


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

© 2019 Lionic

  • LinkedIn - Black Circle
  • Vimeo Black Round
bottom of page