title: SQL Server: how to get a database name as a parameter in a stored procedure
body: <p>I'm trying to create a simple stored procedure which queries a sys.tables table. </p>
  
  <pre><code>CREATE PROCEDURE dbo.test
      @dbname NVARCHAR(255),
      @col NVARCHAR(255)
  AS
      SET NOCOUNT ON
      SET XACT_ABORT ON
  
      USE @dbname
  
      SELECT TOP 100 *
      FROM sys.tables 
      WHERE name = @col
  GO
  </code></pre>
  
  <p>This does not seem to work cause I should put GO after USE @dbname but this terminates the creation of this procedure? How can I put this database selction into this procedure so that a user can give a database name as a parameter for this proc?</p>