Redo Last Change Record

Posted by Prince.pandey7 under ASP.NET on 1/2/2012 | Points: 10 | Views : 832 | Status : [Member] | Replies : 2
hi ,
Suppose i have a multiple record in my table & if i edit a record , but later on if i want to Restore the edited record how is it done .
Please Help me...




Responses

Posted by: Suvendu on: 1/2/2012 [Member] Starter | Points: 25

Up
0
Down
If you are using SQL Server and if you asking for a single transaction then you can do it by rollback transaction. By saying single transaction i mean, if you want the changes to be rollbacked to original state after the immediate insert/update.

But,as far I know there is no way to rollback a permanent change made to the data. Although you can keep the original data by employing a history table.
Just describe your exact need so that someone can help you.

Thanks.

Prince.pandey7, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Prince.pandey7 on: 1/16/2012 [Member] Starter | Points: 25

Up
0
Down
hi ,
Got it , I understood the concept .
thanks a lot .

Prince.pandey7, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response