title: How do I run several .sql scripts from one query?
body: <p>In SQL Server Management Studio, I want to execute a number of SQL scripts (saved queries) one after the other. This is simply to make it easier to run each. I could take each script and combine them all into one massive script and simply execute the lot, however I want it to all be separate so I can easily and simply run each bit by bit.</p>
  
  <p>For example, something like this:</p>
  
  <pre><code>EXEC ('CreateTable1.sql')
  EXEC ('CreateTable2.sql')
  EXEC ('CreateSP1.sql')
  EXEC ('CreateSP2.sql')
  EXEC ('SetupTestData.sql')
  </code></pre>
  
  <p>And that way I can run each line individually and keep everything separate.</p>