create proc youbiao
as
begin
declare @aa int
declare @bb int
declare mycursor cursor for select A,B from a
open mycursor
fetch next from mycursor into @aa,@bb
while @@fetch_status<>0
begin
insert into b(aa,bb) values(@aa,@bb)
fetch next from mycursor into @aa,@bb
end
close mycursor
deallocate mycursor
end
但是这样写，不能将a表中的数据插入到b表中，麻烦看一下，错在那里了，拜托了！！！谢谢啦！！！
