title: How to pass in parameters to a SQL Server script called with sqlcmd?
body: <p>Is it possible to pass parameters to a SQL Server script? I have a script that creates a database. It is called from a batch file using sqlcmd. Part of that SQL script is as follows:</p>
  
  <pre><code>CREATE DATABASE [SAMPLE] ON  PRIMARY 
  ( NAME = N'SAMPLE', FILENAME = N'c:\dev\SAMPLE.mdf' , SIZE = 23552KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
   LOG ON 
  ( NAME = N'SAMPLE_log', FILENAME = N'c:\dev\SAMPLE_log.ldf' , SIZE = 29504KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
  </code></pre>
  
  <p>I want to be able to pass in the filenames for the database and the log so that I don't have to hardcode 'C:\dev\SAMPLE.mdf' and 'C:\dev\SAMPLE_log.ldf'. </p>
  
  <p>Is there a way to do this? I am running Microsoft SQL Server 2008 Express. Let me know if you need any more information.</p>