游标使用

--声明一个游标
DECLARE MyCURSOR CURSOR FOR

SELECT id FROM student

--打开游标
open MyCURSOR

--声明两个变量
declare @id  int
declare @name char(20)
declare @sid int
declare @sname char(60)
declare @pid   int
declare @pname char(60)
declare @cid   int


--循环移动
fetch next from MyCURSOR into @id
while(@@fetch_status=0)
  begin
    select @sid = s.id ,@sname = s.name ,@pid = p.id ,@pname = p.name, @cid = c.cid
           from student s ,score c ,project p
           where s.id = c.sid and p.id =c.pid
 --插入数据
    insert into info
    (id ,sid ,sname ,pid ,pname ,scid)
    values
    (@id ,@sid,@sname,@pid,@pname,@cid)     
    fetch next from MyCURSOR into @id
  end  
close MyCURSOR
deallocate MyCURSOR