各位高手,请帮帮忙!!!!!在线等@!谢谢!!!

[amwsfcomk]

以下这句话,我该如何写呢????
if not exists(select * from @tabname where material_id=@materialid)

谢谢!!!

[gahade]

declare @sql varchar(8000)
set @sql='if not exists(select * from '+@tabname+' where material_id='+rtrim(@materialid)
exec(@sql)

[hellowork]

if not exists(select * from @tabname where material_id= '''' + @materialid + '''')

[amwsfcomk]

谢谢!!!!好像不行呢!
declare @sql varchar(8000)
set @sql='if not exists(select * from '+@tabname+' where material_id='+rtrim(@materialid)
exec(@sql)
begin
exec('
insert into '+@tabname+'(material_id,levelonecode,levelonename,leveltwocode,leveltwoname,levelthreename)
values('''+@materialid+''','''+@onematerialcode+''', '''+@onematerialname+''','''+@twomaterialcode+''', '''+@twomaterialname+''','''+@threematerialname+''')
')
end

我那句话是在前面起一限制作用的,!!谢谢!1!

[gahade]

放在同一个变量里,这样试一下

declare @sql varchar(8000)
set @sql='if not exists(select * from '+@tabname+' where material_id='+rtrim(@materialid)
print(@sql+'
insert into '+@tabname+'(material_id,levelonecode,levelonename,leveltwocode,leveltwoname,levelthreename)
values('''+@materialid+''','''+@onematerialcode+''', '''+@onematerialname+''','''+@twomaterialcode+''', '''+@twomaterialname+''','''+@threematerialname+''')
')

[tgv_mic]

这是干吗呢？ 我咋看都看不懂呢？

[hui_hui_2007]

declare @sql varchar(8000)
set @sql='if not exists(select 1* from '+@tabname+' where material_id='+rtrim(@materialid)
exec(@sql)

[amwsfcomk]

谢谢!各位!!!

declare @sql varchar(8000)
set @sql='if not exists(select * from '+@tabname+' where material_id='+rtrim(@materialid)
exec(@sql+'
insert into '+@tabname+'(material_id,levelonecode,levelonename,leveltwocode,leveltwoname,levelthreename)
values('''+@materialid+''','''+@onematerialcode+''', '''+@onematerialname+''','''+@twomaterialcode+''', '''+@twomaterialname+''','''+@threematerialname+''')
')

这个是正确答案!!!!