How do I make multiple Stored Procedures at once?

How do you script multiple stored procedures?

Option 1: Use the scripting wizard Right-click the db --> tasks --> Generate scripts --> go through the wizard. Option 2: Open the stored procedures folder in SSMS (in the object explorer details window) You can use shift click to select all the stored procedures and you can then right_click and script them to a file.

How do I combine two stored procedures at the same time?

Use the sql server "Generate Script" Wizard. Click Next on the "Introduction" window and in the 2nd screen select the option button "Specific Database objects" and click the combo box near "Stored Procedure" (If you are only taking the scripts of stored procedures.

How many stored procedures can be nested?

You can nest stored procedures up to 32 levels. I would recommend reading over this article regarding INSERT-EXEC. Here is a snippit: If some_sp tries to call some_other_sp with INSERT-EXEC, you will get an error message.

Can stored procedure have multiple queries?

Our developers have gotten this idea lately that instead of having many small stored procedures that do one thing and have small parameter lists that SQL can optimize query plans for, its better to put like 8-10 different queries in the same stored procedure.