如何将参数传递给游标并从两个表中获取记录？

-- 创建存储过程
CREATE PROCEDURE GetRecordsFromTables
    @param1 INT,
    @param2 VARCHAR(50)
AS
BEGIN
    -- 创建游标
    DECLARE @cursor CURSOR;
    
    -- 定义查询语句
    DECLARE @sql NVARCHAR(MAX);
    SET @sql = 'SELECT * FROM Table1 t1
                INNER JOIN Table2 t2 ON t1.id = t2.id
                WHERE t1.column1 = ' + CAST(@param1 AS NVARCHAR) + '
                AND t2.column2 = ''' + @param2 + '''';
    
    -- 执行查询语句
    EXEC sp_executesql @sql;
    
    -- 将结果存储在游标中
    SET @cursor = CURSOR FOR
        SELECT * FROM Table1;
    
    -- 获取记录
    OPEN @cursor;
    FETCH NEXT FROM @cursor;
    WHILE @@FETCH_STATUS = 0
    BEGIN
        -- 处理记录
        -- ...
        
        FETCH NEXT FROM @cursor;
    END;
    CLOSE @cursor;
    DEALLOCATE @cursor;
END;