[MSSQL]TRY…CATCH…通用格式

这一篇很简单,看代码:

USE Dorben
GO
BEGIN TRY
    -- Generate a divide-by-zero error.
    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

 

输出结果