Uitilizando o Commit Rollback Transaction, gravando log de erro
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
BEGIN TRANSACTION BEGIN TRY -- put your T-SQL commands here -- if successful - COMMIT the work COMMIT TRANSACTION END TRY BEGIN CATCH -- handle the error case (here by displaying the error) SELECT ERROR_NUMBER() AS ErrorNumber, ERROR_SEVERITY() AS ErrorSeverity, ERROR_STATE() AS ErrorState, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_LINE() AS ErrorLine, ERROR_MESSAGE() AS ErrorMessage -- in case of an error, ROLLBACK the transaction ROLLBACK TRANSACTION -- if you want to log this error info into an error table - do it here -- *AFTER* the ROLLBACK END CATCH |