如何编写游标通过表并插入到不同表中的sql脚本

DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM source_table;

OPEN cursor_name;

FETCH NEXT FROM cursor_name INTO @variable1, @variable2;

INSERT INTO target_table (column1, column2) VALUES (@variable1, @variable2);

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 插入数据到目标表
    INSERT INTO target_table (column1, column2) VALUES (@variable1, @variable2);
    
    -- 获取下一行数据
    FETCH NEXT FROM cursor_name INTO @variable1, @variable2;
END

CLOSE cursor_name;

DEALLOCATE cursor_name;