游标

--游标（将查询到的二维表数据一行一行的输出）

declare cursor1 cursor

static

for select * from Student;

open cursor1

declare @count int,@i int;

set @i=1;

set @count=@@cursor_rows;

while @i<@count

begin

    fetch next from cursor1;

    set @i=@i+1;

end

close cursor1;

deallocate cursor1;

 

--游标2将每行中对应的数据填充到变量中

declare mystudentinfo cursor

static

for select a.stuid ,a.stuname

from Student a;

open mystudentinfo

declare @count int,@i int;

--取出游标中的总行数

set @count=@@cursor_rows;

set @i=1;

--存放姓名

declare @name varchar(20);

--存放id

declare @id int;

while @i<@count

begin

--into 将对应行中的数据填充到变量中

    fetch next from mystudentinfo into @id, @name;   

    print convert(varchar,@id)+@name;

    set @i=@i+1;

end

close mystudentinfo;

deallocate mystudentinfo;