存储过程中可不可以将参数设为SQL语句

pchelp2008 发布于 2007-03-30 17:00， 477 次点击

INSERT INTO @MypdView select M.ID,M.ShowName,M.PriceTerms,M.Keywords,M.Content,M.hits,S.Corp_name,vip=0 from dbo.Sys_Corporation as S,dbo.MYPD_Information as M where M.UserId=S.id @str and vip<>1 ORDER BY M.id DESC

这样不行，我试了，还有没有别的办法

1 回复

Kendy1234562007-03-30 17:28

Set @sql = 'INSERT INTO @MypdView select M.ID,M.ShowName,M.PriceTerms,M.Keywords,M.Content,M.hits,S.Corp_name,0 from dbo.Sys_Corporation as S,dbo.MYPD_Information as M where M.UserId=S.id '+ @str+' and vip<>1 ORDER BY M.id DESC'

exec (@sql)

这样就可以了