/*
* 游标:将结果集转换成单条记录进行处理的一种机制
*/
--声明游标
DECLARE StuCur CURSOR FOR SELECT studentno,studentname,address FROM Student;
--填充游标(打开)
OPEN StuCur;
--提取
DECLARE @NO INT;
DECLARE @NAME VARCHAR(30);
DECLARE @ADDRESS VARCHAR(50);
FETCH StuCur INTO @NO,@NAME,@ADDRESS;
WHILE(@@FETCH_STATUS=0)
BEGIN
PRINT CONVERT(VARCHAR(10),@NO) + ',' + @NAME + ',' + @ADDRESS;
FETCH StuCur INTO @NO,@NAME,@ADDRESS;
END
--关闭游标
CLOSE StuCur;
--销毁游标
DEALLOCATE StuCur;