I need to update a log table with old and new updated values. Any ideas how can we do this in a trigger?
I need to log all inserts and updates and write a custom message in the column like.. "User John was added by Mark". " Department ABC was updated to xyz in table Department by lily" It's only this column that needs to be updated by trigger actually. All updates and inserts on the table needs to get logged in another log table.