Thank you for explaining the ROWVERSION.
Since you don't have a quick solution to my question, and you know a million times more than I do about SQL Server, I will resort to VFP. I will create a VFP PRG and compare the rows, one at a time, just as I indicated in the other message.
This is not part of the application. I am testing two approaches which create a slightly different data. So, the purpose is simple to see what is missing in one approach or the other.
Thank you for your help.
>A ROWVERSION data type is used in many SQL applications. It's a binary number that SQL assigns when you insert/update a row.
>
>People use it to synchronize tables. If you have a common key across two tables, and you match up the rows based on key....if the rowversion value in Table A is the same as Table B, then you can be assured that no columns are different in B.
>
>But if the rowversions differ, that means "something" is different between the two tables.
>
>OK, I'll say this as delicately as I can. If at all possible, you should take a step back and see what is available in SQL Server. Now, maybe you're stuck with this current structure and don't have any choice in the matter, and I get that. In that case, you're going have to do a brute force comparison. But if you *can* change how this has been set up, there are many features in SQL Server you could take advantage of
>
>
>
>
>
>
>>Yes, I am trying to compare ALL columns.
>>I don't know what ROWVersion is. And since I don't know it, the tables probably do not have it.
>>The tables have a PK but it is a Identity Column so it is meaningless for this comparison.
>>
>>>OK, so you're trying to compare "all" the columns....not just the ID number?
>>>
>>>I'm going to take a guess that your SQL tables don't have a ROWVersion column (which would greatly help here)
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham