suji

 Profile Answers by suji Questions by suji

• Nov 6th, 2011

 

Here is how you can use rollback in any of the SQL Server versions. works in both SQL Server 2000 and later versions.

Code
Begin tran


 


INSERT INTO TABLE VALUES OR updates 


 


rollback tran

SQL Server 2005 or later

Code
BEGIN TRY


   <code what you want TO do>


END TRY


BEGIN CATCH


   <error handling code goes here>


END CATCH

Here is the same with COMMIT transcation

Code
BEGIN TRY


    BEGIN TRAN


 


    INSERT INTO ...


 


    COMMIT TRAN


END TRY


BEGIN CATCH


    EXECUTE <error handling >


END CATCH