We have recently lost 4 students from our student table and are trying to figure out why. I have restored 2 backups from before and after the records were removed and need to compare the 2 tables to single out the exact rows that have been removed.
If there a way to do this in SQL or is it something I will need to do in Excel?
Thanks, Rob