游标

游标的定义

游标的实质是一种能从包括多条数据记录的结果集中每次提取一条记录的机制。
游标中包括结果集和游标位置两个内容。

游标的使用步骤

1. 声明游标

declare cursor_test cursor forselect Number,Name,Age from Studentfor read only 

1. 打开游标
   open cursor_test
2. 读取

fetch next from cursor_test into @Number,@Name,@Agewhile @@FETCH_STATUS = 0begin     print @Number +'   ' + @Name;    fetch next from cursor_test into @Number,@Name,@Ageend

1. 关闭游标
   close cursor_test
2. 释放游标
   deallocate cursor_test

完整代码

declare @Number nvarchar(50);declare @Name  nvarchar(10);declare @Age int;declare cursor_test cursor forselect Number,Name,Age from Studentfor read onlyopen cursor_testfetch next from cursor_test into @Number,@Name,@Agewhile @@FETCH_STATUS = 0begin     print @Number +'   ' + @Name;    fetch next from cursor_test into @Number,@Name,@Ageendclose cursor_testdeallocate cursor_test

总结

当然游标还分为：动态游标、只进游标、键集驱动游标，还有游标声明时指明只读或修改，相信你根据你的需求定制。