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
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
举个例子给楼主参照
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
举个例子给楼主参照
参考资料:http://msdn.microsoft.com/zh-tw/library/ms180169%28v=SQL.100%29.aspx
温馨提示:答案为网友推荐,仅供参考