SQL 存储过程，游标

IF EXISTS(SELECT *FROM sysobjects WHERE id=OBJECT_ID('Proc_fetch_all')) --事先删除存储过程DROP PROCEDURE Proc_fetch_allgoCREATE PROCEDURE Proc_fetch_all AS--当 SET NOCOUNT 为 ON 时，不返回计数（表示受 Transact-SQL 语句影响的行数）。当 SET NOCOUNT 为 OFF 时，返回计数。SET NOCOUNT ON DECLARE @name VARCHAR(20)BEGINDECLARE db_cursor CURSOR SCROLL FOR SELECT Sname FROM Student --创建游标OPEN db_cursor   --打开游标FETCH FIRST FROM db_cursor INTO @nameSELECT @name AS SnameWHILE @@FETCH_STATUS=0  --游标读取下一条数据是否成功BEGINFETCH NEXT FROM db_cursor INTO @nameSELECT @name AS SnameendCLOSE db_cursor  --关闭游标deallocate db_cursor --删除游标endSET NOCOUNT OFFGO EXEC PROC_fetch_all --执行存储过程