Comparing Two Recordsets

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
southofsomewhere
Forum Newbie
Posts: 2
Joined: Sun Jul 24, 2011 8:32 pm

Comparing Two Recordsets

Post by southofsomewhere »

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.
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Comparing Two Recordsets

Post by VladSun »

There are 10 types of people in this world, those who understand binary and those who don't
Post Reply