Differences

This shows you the differences between two versions of the page.

Link to this comparison view

tsql:table_compare [2018/03/10 14:27]
admin created
tsql:table_compare [2018/05/20 13:09] (current)
admin
Line 1: Line 1:
 ====== Table compare ====== ====== Table compare ======
  
-This script generates SQL to compare ​the data in two tables, based on the columns of a specified table.+This script generates SQL to diff the data in two tables, based on the columns of one of them.
  
 For example, if you've created a new version of a table , ''​dbo.MyTable_v2'',​ and you want to compare it to the original ''​dbo.MyTable'',​ you can run this script with ''​@tableName = '​dbo.MyTable'​ ''​. For example, if you've created a new version of a table , ''​dbo.MyTable_v2'',​ and you want to compare it to the original ''​dbo.MyTable'',​ you can run this script with ''​@tableName = '​dbo.MyTable'​ ''​.