cursor简单示例
DELCARE @name varchar(20)
DECLARE cur_name cursor FOR SELECT name FROM sys_user
OPEN cur_name
FETCH NEXT FROM cur_name INTO @name
WHILE @@fetch_status = 0
BEGIN
IF @name =''
--使用break,结束游标
BREAK;
FETCH NEXT FROM cur_name into @name
END
--关闭回收游标,减少资源占用
CLOSE cur_name
DEALLOCATE cur_name
DELCARE @name varchar(20)
DECLARE cur_name cursor FOR SELECT name FROM sys_user
OPEN cur_name
FETCH NEXT FROM cur_name INTO @name
WHILE @@fetch_status = 0
BEGIN
IF @name =''
--使用break,结束游标
BREAK;
FETCH NEXT FROM cur_name into @name
END
--关闭回收游标,减少资源占用
CLOSE cur_name
DEALLOCATE cur_name