Depedns on the size of the data being compared. If not very large and there is a primary key then you could use a select statment with a join to compare the entire row to each other using the PK as the anchor point. However, if large then one side or the other or both have to completely transfer to the SQL server for the comparison so you put a lot of work on the network and the SQL server. It just is complicated not impossible.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)