Try and Catch

Try and Catch. Handling errors.

Last updated: 15 February 2017

Warning: Review and test in a non-production environment before running.

Back to results

BEGIN TRY
    select 1/0
END TRY
BEGIN CATCH
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;
END CATCH;
GO