need to find differences between 2 identical sql tables
- by balalakshmi
I need to find differences between 2 identical sql tables
Each table is being uploaded from a 3rd paty tool into sqlserver database.
The table structure is:
Issue ID-status-Who
Issue ID will not repeated within a table, though its not defined explicitly as primary Key
There could be additions/deletions/Updations between any 2 tables.
What I need
Number of rows added & their details
Number of rows deleted & their details
Number of rows deleted & their details
How do I do this
1) is it better to use sql
2) or use datatables