sybase游标问题

luobinhan588

免费乐捐，感谢支持

declare @s varchar(8000)
declare tb cursor for
select s = 'select * from cheshou '
open tb
fetch tb into @s
while @@sqlstatus=0
begin
exec(@s)
fetch tb into @s
end
close tb
deallocate cursor tb



执行后出错如下：
Server Message:  Number  7344, Severity  15
Line 7:
DECLARE CURSOR must be the only statement in a query batch.
Server Message:  Number  11721, Severity  15
Line 11:
Global variables not allowed as defaults.
找了半天也没找出原因，各位大侠能否告诉我一下是什么问题，谢谢了！

ehxz

参考一下，你的不知道处理了啥数据
declare @temp_shop varchar(40)
declare cur_shop cursor for
select ORGAN_ID
from F_SALE_DEPT
where ORGAN_ID LIKE "2%"
OPEN cur_shop
fetch cur_shop into @temp_shop
while @@sqlstatus = 0
begin
exec up_accrpt_zyposinout @arg_year,@arg_prd,"",@temp_shop,"n","y"
  fetch cur_shop into @temp_shop
end
close cur_shop
DEALLOCATE cursor cur_shop