Redo Last Change Record

Posted by Prince.pandey7 under ASP.NET on 1/2/2012 | Points: 10 | Views : 1635 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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...

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	hi , Got it , I understood the concept . thanks a lot . Prince.pandey7, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts