sqlserver for循环游标循环

	--声明变量,用户接收循环时的变量
	declare @name nvarchar(20) ,
			@age nvarchar(20) ,
			@class nvarchar(20)
	
	declare sherLcursor cursor for  select name,age,class from person
	--打开游标
	open sherLcursor	 
	fetch next from sherLcursor into @name,@age,@class
	
	while (@@fetch_status=0)
		
	begin	
	--打印查询的变量值 
		select @name,@age,@class
	--用游标去取下一条记录
	   fetch next from sherLcursor into @name,@age,@class
	end
	--关闭游标
	close sherLcursor
	--撤销游标
	DEALLOCATE sherLcursor