Results 1 to 2 of 2

Thread: Roll Back

  1. 08-30-2005, 02:26 AM #1
    chaya
    chaya is offline Registered User
    Join Date
    Jul 2005
    Posts
    24

    Roll Back

    hi,
    how to use ROLL BACK in SQL query?

    plz help me,
    thanks in advance.
    Reply With Quote Reply With Quote
  2. 08-30-2005, 08:03 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There is no ROLLBACK for a query, it is only for INSERT, UPDATE and DELETEs.

    You need

    BEGIN TRAN

    then based on when you want to roll back, issue

    ROLLBACK

    If you are using Oracle, BEGIN TRAN is implicit, so you can issue ROLLBACK without BEGIN TRAN in SQL PLus.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules