Results 1 to 2 of 2

Thread: rollback

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Exclamation Unanswered: rollback

    how to rollback(undo) record was i deleted???

    pls tell me...

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    rollback can only be used within the context of a transaction.... eg.

    begin transaction
    do some stuff
    delete a record
    do some other stuff
    if the is a problem
    rollback
    else
    commit
    end transaction

    so if you have just deleted a row by going delete from table where X=X then you are stuck unless you have a backup....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •