CREATE procedure 过程名 as declare a int declare b int declare c int declare 游标1 cursor for select a,b,c from 表1 open 游标1 fetch 游标1 into @a,@b,@c while @@fetch_status = 0 begin insert 表2 values(@a,@b,@c) fetch 游标1 into @a,@b,@c end close 游标1 deallocate 游标1
CREATE procedure 过程名
as
declare a int
declare b int
declare c int
declare 游标1 cursor for
select a,b,c from 表1
open 游标1
fetch 游标1 into @a,@b,@c
while @@fetch_status = 0
begin
insert 表2 values(@a,@b,@c) fetch 游标1 into @a,@b,@c
end
close 游标1
deallocate 游标1