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

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

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)

这样就可以了