Click here to Skip to main content
15,946,179 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?

Thanks
sameer
Posted

While updating record,
SQL
update tbl1 set colprev = colcurr, colcurr = 'abc' where colid=1

Happy Coding!
:)
 
Share this answer
 
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?


Thanks
sameer
 
Share this answer
 
Comments
Aarti Meswania 1-Apr-13 8:12am    
use "Have a Question or Comment?" button given bellow the answer,
for asking query.

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