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.
Comparing Two Recordsets
Moderator: General Moderators
-
southofsomewhere
- Forum Newbie
- Posts: 2
- Joined: Sun Jul 24, 2011 8:32 pm
Re: Comparing Two Recordsets
There are 10 types of people in this world, those who understand binary and those who don't