SQL游标有关问题请问

2012-06-24

SQL游标问题请教我写了一个游标，内容如下：SQL codeDECLARE @A001 char(100),@A005 Numeric(16,6),@A006 Nu

SQL游标问题请教
我写了一个游标，内容如下：

SQL code

DECLARE @A001 char(100),@A005 Numeric(16,6),@A006 Numeric(16,6) SELECT  @A006 = 0DECLARE CAAA  CURSOR  FORSELECT A001,A005 FROM @AA FOR UPDATEOPEN CAAAFetch Next FROM CAAA INTO @A001,@A005WHILE(@@FETCH_STATUS = 0)  UPDATE @AA SET A006 = @A006 + A005 FROM @AA WHERE CURRENT OF CAAA  Fetch Next FROM CAAA INTO @A001,@A005CLOSE CAAADEALLOCATE CAAA

我的游标是放在一个函数里面，不加游标，函数执行行就5行数据。
但是加的游标后，1个小时都没查询结果出来，问题出在哪里？

[解决办法]

SQL code

DECLARE @A001 char(100),@A005 Numeric(16,6),@A006 Numeric(16,6) SELECT  @A006 = 0DECLARE CAAA  CURSOR  FORSELECT A001,A005 FROM @AA FOR UPDATEOPEN CAAAFetch Next FROM CAAA INTO @A001,@A005WHILE(@@FETCH_STATUS = 0)BEGIN  UPDATE @AA SET A006 = @A006 + A005 FROM @AA WHERE CURRENT OF CAAA  Fetch Next FROM CAAA INTO @A001,@A005ENDCLOSE CAAADEALLOCATE CAAA

热点排行

SQL Server

SQL游标有关问题请问