title: Passing table name in sql stored procedure
body: <p>Is it possible to pass the table name as input parameter to the stored procedure?</p>
  
  <p>For example:</p>
  
  <pre><code>create procedure test
  @tablename char(10)
  as
  begin
  select * from @tablename
  end
  go
  </code></pre>
  
  <p>I know this does not work. So what is the best way if I want to pass the table name into the stored procedure?</p>
  
  <p>Many thanks</p>