I have a table which I copied some time back as a back up.
In the original table some records are removed or changed.
The problem is that IDs of the two tables are different.
Is there a way to compare the records of each table and point out any record is changed or added or removed?
I would know how to write a program and compare the contents but I was wondering if there was a sql command to do that?
I am using ms sql.