如何将存储过程中的多个结果存储到数据集中？

CREATE PROCEDURE GetMultipleResults
AS
BEGIN
    DECLARE @ResultSet1 TABLE (ID INT, Name NVARCHAR(50))
    DECLARE @ResultSet2 TABLE (ID INT, Value NVARCHAR(50))

    INSERT INTO @ResultSet1 (ID, Name)
    SELECT ID, Name FROM Table1

    INSERT INTO @ResultSet2 (ID, Value)
    SELECT ID, Value FROM Table2

    DECLARE @Cursor CURSOR
    SET @Cursor = CURSOR FOR
    SELECT * FROM @ResultSet1
    UNION ALL
    SELECT * FROM @ResultSet2

    OPEN @Cursor
    FETCH NEXT FROM @Cursor
    WHILE @@FETCH_STATUS = 0
    BEGIN
        -- Process each row
        FETCH NEXT FROM @Cursor
    END
    CLOSE @Cursor
    DEALLOCATE @Cursor
END

CREATE PROCEDURE GetMultipleResults
AS
BEGIN
    DECLARE @ResultSet1 TABLE (ID INT, Name NVARCHAR(50))
    DECLARE @ResultSet2 TABLE (ID INT, Value NVARCHAR(50))

    INSERT INTO @ResultSet1 (ID, Name)
    SELECT ID, Name FROM Table1

    INSERT INTO @ResultSet2 (ID, Value)
    SELECT ID, Value FROM Table2

    SELECT * FROM @ResultSet1
    UNION ALL
    SELECT * FROM @ResultSet2
END

CREATE PROCEDURE GetMultipleResults
AS
BEGIN
    CREATE TABLE #ResultSet1 (ID INT, Name NVARCHAR(50))
    CREATE TABLE #ResultSet2 (ID INT, Value NVARCHAR(50))

    INSERT INTO #ResultSet1 (ID, Name)
    SELECT ID, Name FROM Table1

    INSERT INTO #ResultSet2 (ID, Value)
    SELECT ID, Value FROM Table2

    SELECT * FROM #ResultSet1
    UNION ALL
    SELECT * FROM #ResultSet2

    DROP TABLE #ResultSet1
    DROP TABLE #ResultSet2
END