sqlserver 存储过程输出异常


BEGIN
    BEGIN TRY
        -- 可能出错的逻辑
        SELECT 1 / @param
    END TRY
    BEGIN CATCH
        -- 输出错误信息
        SELECT 
            ERROR_NUMBER()   AS ErrorNumber,
            ERROR_MESSAGE()  AS ErrorMessage,
            ERROR_SEVERITY() AS ErrorSeverity,
            ERROR_STATE()    AS ErrorState,
            ERROR_LINE()     AS ErrorLine,
            ERROR_PROCEDURE() AS ErrorProcedure;

        -- 或者用 RAISERROR / THROW 重新抛出
        THROW;
    END CATCH
END

07日15日,星期三,在这里每天60秒读懂世界!

07日14日,星期二,在这里每天60秒读懂世界!

评 论
更换验证码