Ryan.Ruan

摘要： 创建游标declare myCursor cursor forselect [name] from [table]//declare @result int declare @final_result int打开游标open myCursor定义游标结果集的单个对象declare @subname sysname//declare @sql nvarchar(500)执行游标-代码fetch next from myCursor into @subnamewhile(@@fetch_status=0) //游标遍历状态：0为成功 begin set @sql='select coun. 阅读全文