SQL Sage Note-using a transaction mechanism when a stored procedure contains large amounts of SQL

1 --The transaction starts, and if there is a system error in the middle, roll back2      BEGINTRY3              BEGIN TRAN 4            --all scripts for stored procedures5                     SELECT *6                      from#raw_data7                     WHEREId= @rowNo8 9               COMMIT TRAN Ten      ENDTRY One      BEGINCATCH A      ROLLBACK TRAN       -        --System Error -         INSERT   intoStore_batch_import_templog the (Remark -                             ) -                             SELECT  'System Error' , -          +      ENDCATCH -  +            

SQL Sage Note-using a transaction mechanism when a stored procedure contains large amounts of SQL