Click here to Skip to main content
15,942,934 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello experts !

How to track changes in the specific column on update. The column results shows both values previous and current?


Hi Aarti,
Thanks for your relpy !
if i need to see only a affected rows means when value is inserted and user try to update the record . How can i track those changes for last 100 days on date stamp?

Share this answer
Aarti Meswania 1-Apr-13 8:12am    
use "Have a Question or Comment?" button given bellow the answer,
for asking query.
While updating record,
update tbl1 set colprev = colcurr, colcurr = 'abc' where colid=1

Happy Coding!
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900