As part of "rollback" solution, For each update, I would like to create separate Update statement to undo the values.
So we could execute this update statement for Rollback purpose.
I am looking for generic update statement.
Requirement is below,
I have to pass below input parameters
list of columns to be updated,
value for condition column
When i execute the query, then update statement should display in result set so that I can commit this statement in Rollback folder
Trying to achieve this using dynamic query. Please help on this.