DECLARE @studyNum VARCHAR(10),@Name VARCHAR(10)
DECLARE stu_cur SCROLL CURSOR FOR
SELECT Stu_ID,Stu_Name FROM StuInfo
OPEN stu_cur
--开启游标之后,默认是位于第一行的前面,因此需要FETCH NEXT
FETCH NEXT FROM stu_cur INTO @studyNum,@Name
WHILE (@@FETCH_STATUS = 0)--判断是否有数据
BEGIN
PRINT @Name +'的学号是:'+@studyNum +'。'
FETCH NEXT FROM stu_cur INTO @studyNum,@Name--游标前进
END
CLOSE stu_cur
DEALLOCATE stu_cur
参考地址:http://www.cnblogs.com/youngberry/archive/2009/07/17/1525647.html