Hope someone can help.
We're going to be doing some data appending to three tables in our production database and we need to have a foolproof way of making sure the existing data doesn't get touched (this is being done via the front end of the software that sits on top of the SQL database).
I could take copies of the three tables before, dump them out to Excel, create a unique id by concatenating all the columns together and then do the same with the tables after; I'd then use a VLOOKUP in Excel to validate the before data hadn't been touched.
But that's very long winded and cpu / memory intensive.
Is there a way of adding a column containing a hashcode based on all preceding columns to my "before" tables?
So my table might look like
UID Name Address Postcode Hashcode 001 Fred 10 High St TR12 5HJ 0B675VC
Thanks in advance.