存储过程
代码如下:

............................
IF EXISTS(SELECT * FROM tab_SysProp WHERE LevelOneName=@onematerialname)
begin
update tab_SysProp
set LevelOneName=@onematerialnamenew
where LevelOneName=@onematerialname
end

IF EXISTS(SELECT name FROM sysobjects where name=@tabname)
begin
exec
( '
update '+@tabname+ ' set LevelOneName=@onematerialnamenew
where LevelOneName=@onematerialname
')
end


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


第一个更新可以,第二个就不行了报@onematerialnamenew没有定义,谢谢!

[解决办法]
exec
( '
update '+@tabname+ ' set LevelOneName=@onematerialnamenew
where LevelOneName=@onematerialname
')

exec
( 'update '+@tabname+ ' set LevelOneNmae= ' ' '+@onematerialnamenew+ ' ' ' where LevelOneName= ' ' '+@onematerialname+ ' ' ' ')
[解决办法]
IF EXISTS(SELECT name FROM sysobjects where name=@tabname)
begin
exec
( 'update '+@tabname+ ' set LevelOneName= ' ' '+@onematerialnamenew+ ' ' '
where LevelOneName= '+@onematerialname)
end