title: How to create multiple stored procedures from .sql files
body: <p>I have about 100 stored procedures files that I want to add to a new database that I created. Is there any way I can just drop them in a folder to import them? When I tried that, like how you would with windows explorer, it just opened them all in query windows.</p>
  
  <p>I am using SQL Server Management Studio.</p>