游标使用问题

[DG_1]

declare @zdhm varchar(50)
set @zdhm='zd00047' --更改单引号中的制单号码
declare tb cursor for
Select name from sysobjects Where xtype='U'
declare @name sysname
open tb
fetch next from tb into @name
while @@fetch_status=0
begin
delete from @name where zdhm=@zdhm
fetch next from tb into @name
end
close tb
deallocate tb

错误提示如下
服务器: 消息 137，级别 15，状态 2，行 10
必须声明变量 '@name'。

我不是已声明变量了么,请问怎样解决,谢谢!

[jsldhy]

delete from @name where zdhm=@zdhm
这一句是个不小的错误噢！
delete ?
from @name ???
我也是一个小小的菜鸟，但是好象declare 是定义变量的，定义临时表以#开始？！
我建议：去掉declare @name sysname这一句
然后把@name都改为#name。OK！

[zjcxc]

declare @zdhm varchar(50)
set @zdhm='zd00047' --更改单引号中的制单号码
declare tb cursor for
Select name from sysobjects Where xtype='U'
declare @name sysname
open tb
fetch next from tb into @name
while @@fetch_status=0
begin
exec('delete from '+@name+' where zdhm='''+@zdhm+'''')
fetch next from tb into @name
end
close tb
deallocate tb

[lengxiaowei]

变量不能直接放SQL里面使用,
要通过字符串的形式来使用,

支持邹键大哥的

[orcale]

delete from @name where zdhm=@zdhm=>
要寫成動態sql
exec('delete from '+@name +' where zdhm='+''''+@zdhm+'''')

[DG_1]

:)多谢各位!!!