Can stored procedure have multiple queries?

Question

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. 16 сент. 2015 г.

Can stored procedure have multiple SELECT statements?

Each procedure has one or more statements. In our case, these are SQL statements. So, you can write a procedure that will – insert new data, update or delete existing, retrieve data using the SELECT statement. And even better, you can combine more (different statements) in the stored procedures.

Can you run multiple SQL queries at once?

You can include multiple SQL statements on the SQL query panel. The exceptions are CALL and CREATE PROCEDURE statements. These statements must be used alone in a query.

Can a stored procedure return multiple tables?

Stored procedures can return multiple result sets.

Can a procedure have more than one parameter?

Explanation. Just like you have the ability to use parameters with your SQL code you can also setup your stored procedures to accept one or more parameter values.

Expert · Answer