首页 默认分类 正文
  • 本文约281字,阅读需1分钟
  • 120
  • 0

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
评论
更换验证码
友情链接