Results 1 to 3 of 3

Thread: Revert back previous transaction

  1. #1

    Revert back previous transaction

    Dear

    If I delete all the records from a table then is there any way to restore those records in sql server


  2. #2
    Contributing Member
    Join Date
    Jun 2007
    Answers
    65

    Re: Revert back previous transaction

    Quote Originally Posted by nitesh.aggarwal View Post
    dear if i delete all the records from a table then is there any way to restore those records in sql server
    yes nitesh, you can by rollback transaction if have set begin transaction before deleting the records like

    BEGIN TRAN
    Delete from table
    ROLLBACK TRAN

    ---v v---
    Vikas Vaidya
    [please mark it as thank if you found the answer useful]

    Last edited by vikasvaidya; 04-14-2008 at 01:08 AM. Reason: bad format

  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Revert back previous transaction

    You can rollback the transactions to restore to previous state.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact