存储过程问题

[notruiyi]

请问存储过程中能使用游标吗？
如何使用？
begin end中能定义变量吗？

[Tongls]

是可以使用，只是性能比较低，不推荐使用！ 尽量使用别的方法解决！

[notruiyi]

create procedure ReportBuilder(
@fromDate datetime,
@balanceIn , real)
as
begin

//声明游标，指向比指定日期后的记录
declare buildReportCur SCROLL CURSOR for
select debit,lender ,balance from b_bills

open buildReportCur

declare @debitValue real
declare @lenderValue real
declare @balanceValue real
declare @lastBalance real

set @lastBalance = @balanceIn

FETCH first from buildReportCur into @debitValue,@lenderValue,@balanceValue

while(@@FETCH_STATUS = 0)
begin
set @lastBalance = @lastBalance +@debit- @lenderValue
update buildReportCur set balance = @lastBalance where CURRENT OF buildReportCur
FETCH NEXT from buildReportCur into @debitValue,@lenderValue,@balanceValue
end
end

end

[jiushaoye]

游标性能差,速度慢,还是用别的办法好!
当然可以定义变量,如 declare @v int