T-Sql如何从另一个存储过程中的storedproc返回一个表

CREATE PROCEDURE storedproc
AS
BEGIN
    DECLARE @TempTable TABLE (Column1 INT, Column2 VARCHAR(50))

    INSERT INTO @TempTable
    SELECT Column1, Column2 FROM YourTable

    SELECT * FROM @TempTable
END

CREATE PROCEDURE storedproc
AS
BEGIN
    CREATE TABLE #TempTable (Column1 INT, Column2 VARCHAR(50))

    INSERT INTO #TempTable
    SELECT Column1, Column2 FROM YourTable

    SELECT * FROM #TempTable

    DROP TABLE #TempTable
END