I need to log historical changes to personal details in a table but don't really care about insertions or deletions.
I notice that the default trigger includes in it's update section something like:
INSERT INTO [tablename_Audit]
([field1],[field2],[field3])
VALUES
(@FIELD1, @FIELD2, @FIELD3)
This logs the current value the data was changed to but I would prefer a...
