游标变量找不到了？？

[smalldeer]

在游标循环期间执行存储过程

Declare @dav as varchar(100)
Declare cursor5 cursor for select title from title
open cursor5
fetch cursor5 into @dav
while @@fetch_status=0
begin
set @sql='.....'
exec sp_executesql @sql --执行一个存储过程
fetch cursor5 into @dav
end
close cursor5 ---关闭游标
Deallocate Cursor5 ---删掉游标


报错
@dav变量未定义

[shuiniu]

把这句先注释掉exec sp_executesql @sql ！
看看报不报错！！

[pengdali]

你出错得地方在

set @sql='.....'
exec sp_executesql @sql --执行一个存储过程

这里面

[pengdali]

set @sql='exec 过程名 '''+@dav+''''
exec sp_executesql @sql

[txlicenhe]

请楼主出示全部代码

[smalldeer]

谢谢大力

我的过失

谢谢

[kseven]

Declare @dav as varchar(100)
Declare cursor5 cursor for select a from c
open cursor5

while @@fetch_status=0
begin
fetch next from cursor5 into @dav
set @sql=' '
exec sp_executesql @sql --执行一个存储过程
end
close cursor5 ---关闭游标
Deallocate Cursor5 ---删掉游标

[shuiniu]

代码没问题呀！

[tangxc2003]

Declare @dav as varchar(100)
Declare cursor5 cursor for select title from title
open cursor5
fetch next from cursor5 into @dav
while @@fetch_status=0
begin
set @sql='.....'
exec sp_executesql @sql
fetch next from cursor5 into @dav
end
close cursor5
Deallocate Cursor5

[smalldeer]

还是报错？？