27,579
社区成员
发帖
与我相关
我的任务
分享
DECLARE @a VARCHAR(20),@b VARCHAR(20)
DECLARE table1_cursor CURSOR
FOR SELECT a,b FROM table1
OPEN table1_cursor
FETCH NEXT FROM table1_cursor INTO @a,@b
WHILE @@FETCH_STATUS=0
BEGIN
这里用存储过程处理 @a,@b
--处理完后将 @a,@b insert到table2里面
......
FETCH NEXT FROM table1_cursor INTO @a,@b
END
CLOSE table1_cursor
DEALLOCATE table1_cursor
DECLARE @a VARCHAR(20),@b VARCHAR(20)
DECLARE table1_cursor CURSOR
FOR SELECT a,b FROM table1
OPEN table1_cursor
FETCH NEXT FROM authors_cursor INTO @a,@b
WHILE @@FETCH_STATUS=0
BEGIN
--处理将table1数据insert到table2的相关逻辑
......
FETCH NEXT FROM authors_cursor INTO @a,@b
END
CLOSE table1_cursor
DEALLOCATE table1_cursor
--声明游标
DECLARE AccountCursor
CURSOR FOR SELECT id FROM tb
--打开游标
declare @accountid int
open AccountCursor
FETCH NEXT FROM AccountCursor
INTO @AccountID
WHILE @@FETCH_STATUS = 0
begin
--取第一行的值给变量
--执行语句
INSERT INTO result
SELECT [ID],[Name1]
FROM tb
WHERE [ID] = @AccountID
FETCH NEXT FROM AccountCursor
INTO @AccountID
end
CLOSE AccountCursor
--释放游标
DEALLOCATE AccountCursor
insert into table2(a,b)
select 处理(a),处理(b) from table1
insert into (a,b)
select 处理(a),处理(b) from table1
insert table2
select a+1, b+2 from table1