关于存储过程表传参数问题,高手请进!解决了马上给分.

Question

CREATE proc QID @a2  varchar 
as
begin    
     exec('select * from '+@a2)
end

Answer 1

CREATE proc QID @a2  varchar(50)
as
begin    
     exec('select * from '+@a2)
end

Answer 2

CREATE proc QID(@a1  varchar ,@a2  varchar ,@a3  varchar ,@a4  int  output)
--a1字段名  a2表名 a3  字段值 
as
begin
       exec ( 'select 1 from '+ @a2+' where '+@a1+'='+@a3)
       if @@rowcount<0
       begin
           set @a4 =0
       end
      else
       begin
           set @a4 =1
       end
        
end