从嵌套的MSSQL过程到父过程的错误传递

-- 子过程
CREATE PROCEDURE ChildProcedure
AS
BEGIN
    -- 假设这里发生了一个错误
    RAISERROR('An error occurred in the child procedure.', 16, 1)
END
GO

-- 父过程
CREATE PROCEDURE ParentProcedure
AS
BEGIN
    BEGIN TRY
        -- 调用子过程
        EXEC ChildProcedure
    END TRY
    BEGIN CATCH
        -- 捕获并处理错误
        DECLARE @ErrorMessage NVARCHAR(4000);
        DECLARE @ErrorSeverity INT;
        DECLARE @ErrorState INT;

        SELECT 
            @ErrorMessage = ERROR_MESSAGE(),
            @ErrorSeverity = ERROR_SEVERITY(),
            @ErrorState = ERROR_STATE();

        -- 输出错误信息
        PRINT 'Error Message: ' + @ErrorMessage;
        PRINT 'Error Severity: ' + CAST(@ErrorSeverity AS NVARCHAR(10));
        PRINT 'Error State: ' + CAST(@ErrorState AS NVARCHAR(10));
    END CATCH
END
GO

-- 调用父过程
EXEC ParentProcedure