我对游标怎么这么晕呼啊

CREATE PROCEDURE www_Scheme
AS
declare @fdReportXXXID as varchar(50),
@fdBudgetFC as varchar(200),
@fdBudgetCode as varchar(200),
@fdBudgetFCAll as varchar(500) //定义3个变量
declare c1 cursor for //一个游标
select distinct fdReportSchemeID
from tbSchemeBalance
order by fdReportSchemeID
open c1 //使用前打开游标
fetch next from c1 into @fdReportXXXID //取得第一个游标值
while @@FETCH_STATUS = 0 //循环
begin
set @fdBudgetFCAll = '' //设置变量fdBudgetFCAll的变量值
declare c2 cursor for select fdBudgetFC, fdBudgetCode
from tbSchemeBalance
where fdReportSchemeID = @fdReportXXXID and fdIsTotal = 1

open c2

fetch next from c2 into @fdBudgetFC, @fdBudgetCode
while @@FETCH_STATUS = 0
begin
set @fdBudgetFCAll = @fdBudgetFCAll
+ @fdBudgetCode
+ ':'
+ @fdBudgetFC
+ ' '
fetch next from c2 into @fdBudgetFC, @fdBudgetCode
end

我标记

SQL里我怎么控制游标？ 我的jsp程序怎么出现 游标错误了,是什么意思? 他怎么这么对我? 怎么看游标直径尺 SQL里游标到底是什么，且怎么使用游标！！ 她怎么可以这么对我？ 他怎么老这么对我啊!! 他怎么可以这么对我！ 难过..他怎么这么对我 男朋友怎么能这么对我