I'm looking for a better way to find out if a record has been updated or if a new record has been inserted. At the moment I'm checking the differences record by record for each table and with a lot of data it does take a while. Any ideas ?
Some time back I was looking for something similar
Unfortunately I am told this isn't possible using SQL in its current state, a record by default doesn't hold this info
The only way it can be done (that I am aware of) is to add an extra field (or 2 if you feel the need) which retain the date a record was created/last amended
Every time a record is added/amended update this field
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.