Please reload

Recent Posts

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 metho...

What Changed? Using T-SQL to Find Differences Between Tables

August 31, 2017

1/1
Please reload

Featured Posts

What Changed? Using T-SQL to Find Differences Between Tables

August 31, 2017

 

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?

 

  

 

 

Share on Facebook
Share on Twitter
Please reload

Follow Us

I'm busy working on my blog posts. Watch this space!

Please reload

Search By Tags
Please reload

Archive
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square

© 2019 Lionic

  • LinkedIn - Black Circle
  • Vimeo Black Round