The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
• Table A has 5 fields (id, a integer, b varchar, c int, d varchar, e varchar) all integers
• Design a table A_Audit which tracks the changes to Table A
• Every time Table A is updated, Table A_Audit gets updated with the original record, the changed value (field level), the time stamp and the user id. At any point in time, I should be able to see what A_Audit has and how A's value has changed
• A report is generated at the end, which comprehensively shows the difference between Table A and A_Audit and what was changed, when and by whom.
. Need well documented T-SQL code (can be modularized) that can achieve all of the above
IMPORTANT: Need this done by Tuesday (10/2)
Sign in or Register to see more