Friday, July 5, 2013

Begin Tran and End Tran Example



BEGIN TRAN T1  



 ( code) 



  IF 

                            @@ERROR<> 0  

       BEGIN 

         RAISERROR ('ERROR OCCURS SELECTING.', 16, 1)  

         ROLLBACK  TRAN T1  

         RETURN 

       END 

  ELSE   

       BEGIN 

        COMMIT 

        TRAN T1  

       END   

No comments:

Post a Comment