Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2013
    Posts
    3

    Unhappy Unanswered: i want sql query that when i click on cancel query button then transactn rolled back

    i want sql query that when i click on cancel query button then all the transaction must be rolled back. plz do needful plz. mail me at patilsatish022@gmail.com

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code:
    BEGIN TRAN
    
        ...do stuff...
    
    COMMIT TRAN
    This will treat everything in the middle as a single transaction so will not commit any steps until the last one is completed.
    George
    Home | Blog

  3. #3
    Join Date
    Dec 2013
    Posts
    3

    Red face i want sql query that when i click on cancel executing query button the transaction

    i want sql query that when i click on cancel executing query button the transaction must be rolled back and that record should not entered in main table in sql server

  4. #4
    Join Date
    Dec 2013
    Posts
    3

    Red face i want sql query that when i click on cancel executing query button the transaction

    i want sql query that when i click on cancel executing query button the transaction must be rolled back and that record should not entered in main table in sql server

Tags for this 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
  •