在SQL Server 2005上开始Try Catch,如何将错误信息发送给调用的父级?

你有这个程序

    CREATE PROCEDURE dbo.test1
    AS
    BEGIN
        begin transaction
        begin try
          exec dbo.test2
          commit transaction
        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
           rollback transaction
        end catch
    END

这一个

    CREATE PROCEDURE dbo.test2
    AS
    BEGIN
        begin transaction
        begin try

          commit transaction
        end try
        begin catch
           rollback transaction
            if @@trancount = 0
            begin
                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
             else
                --return the select above to the parent while raising an error
        end catch
    END

如何将错误重新引发到调用父级?

我知道我能做到;

  raiserror(ERROR_MESSAGE(),ERROR_SEVERITY(),ERROR_STATE())

但是如何得到 Error线() , 错误_过程() 和 错误编号() ?

如果可能的话,我需要能够在每次捕获中都做同样的选择