How to Capture updated values in table

Thats great idea to track log of modification or back up you old data for future use....

for achieving this you need to do like this...

1) first of all you need to add one table, that table will used for storing old value before it will be updated.....

Schema Like this...

ID,TABLENAME,COLUMNAME,RecordID,OLDVALUE,UPDATEDVALUE

//here Record ID means the primary key or id of your record

2) then create a trigger that will perform operation for backup your old data before modified that....

3) then you can use that backup data for for showing old value with updated value...

For more about trigger you can please refer this link...

how to check whether it is inserte or update or delete in how to check whether it is update or delete in sql server trigger..?[^]