如何从存储过程的SQL Server返回多个数据表？

CREATE PROCEDURE MultipleDataTables
AS
BEGIN
    -- Declare table variables
    DECLARE @Table1 TABLE (ID INT, Name NVARCHAR(50))
    DECLARE @Table2 TABLE (ID INT, Value NVARCHAR(50))

    -- Insert data into table variables
    INSERT INTO @Table1 (ID, Name)
    SELECT 1, 'John'
    UNION ALL
    SELECT 2, 'Jane'

    INSERT INTO @Table2 (ID, Value)
    SELECT 1, 'Value1'
    UNION ALL
    SELECT 2, 'Value2'

    -- Return table variables
    SELECT * FROM @Table1
    SELECT * FROM @Table2
END

EXEC MultipleDataTables