VS2005中调用存储过程报变量没有定义解决思路

VS2005中调用存储过程报变量没有定义
代码如下:

............................
IF   EXISTS(SELECT   *   FROM   tab_SysProp   WHERE   [email protected])
begin
update   tab_SysProp  
set   [email protected]
where   [email protected]
end

IF   EXISTS(SELECT   name   FROM   sysobjects   where   [email protected])
begin
exec
( '
update   '[email protected]+ '   set   [email protected]
    where   [email protected]
')
end


.............................


第一个更新可以,[email protected],谢谢!

------解决方案--------------------
exec
( '
update '[email protected]+ ' set [email protected]
where [email protected]
')

exec
( '
update '[email protected]+ ' set LevelOneName= ' ' '[email protected]+ ' ' '
where LevelOneName= ' ' '[email protected]+ ' ' ' ')