在存储过程中执行别的存储过程并返回其结果集

CREATE TABLE TestTable ( ID INT )

INSERT  INTO TestTable
        SELECT  1
        UNION
        SELECT  2
        UNION
        SELECT  3
go

select * from TestTable

CREATE PROCEDURE [dbo].[UP_B]
AS
BEGIN
      SELECT ID,'ComeFromB' FROM TestTable      
END
go

CREATE PROCEDURE [dbo].[UP_A]
AS
BEGIN
      CREATE TABLE #Temp (ID INT,Msg VARCHAR(30))
      INSERT INTO #Temp EXEC UP_B
     
      SELECT * FROM #Temp    
END
go

EXEC [UP_A]
go