Comparing Two Recordsets
Posted: Thu Aug 04, 2011 8:14 pm
I have two tables that are structured exactly the same. Same number of columns, same order of columns, datatypes, etc. However, the tables could potentially contain different data.
I was curious as to how to output the diff between the two. If they're the same, the output should be nothing. Note that the tables do contain text fields, so I've tried things such as EXCEPT, but I get an error stating that it's not usable on the TEXT datatype. This is MSSQL.
I was curious as to how to output the diff between the two. If they're the same, the output should be nothing. Note that the tables do contain text fields, so I've tried things such as EXCEPT, but I get an error stating that it's not usable on the TEXT datatype. This is MSSQL.