title: Creating a bat file which executes SQL scripts
body: <p>I have a folder into which a number of MSQL scripts get dropped into after each weekly sprint. For example, 10 scripts were placed into the folder today. I had to then open each script individually and run it against the applicable database. The database that it needs to be run against is in the name of the file.
  e.g. [2] [CRMdata]UpdateProc.sql</p>
  
  <p>The [2] represents the sequence in which it is run, so script [1] needs to be run before it.
  [CRMdata] is the database I have to run it against.</p>
  
  <p>This process is very tiresome, especially if there are 50 scripts to run sequentially.
  I was wondering if there was an easier way to do this?
  Perhpas a .bat file, which reads the filename, and executes the scripts sequentially based on the script number, as well as executing it against the database specified in the file name.</p>
  
  <p>Any help is much appreciated.
  Thanks.</p>