Question

SQL中，定义一个游标，逐行读取学生表中的数据，怎么写

declare cursor_xs cursor for
select * from 学生表
open cursor_xs
fetch next from cursor_xs
while @@fetch_status=0
begin
fetch next from cursor_xs
end
close cursor_xs
deallocate cursor_xs

Answer 1

DECLARE Roy CURSOR FOR
SELECT TOP 3 * FROM sysobjects
OPEN Roy
FETCH NEXT FROM Roy
WHILE @@FETCH_STATUS=0
BEGIN
FETCH NEXT FROM Roy
END
CLOSE Roy
DEALLOCATE Roy

举个例子给楼主参照