What is a stored procedure

Question

119

What is a "stored procedure" , how do they work?

What is the build-up for stored procedure (also list the things which are must  to be a stored procedure)?

Answer 1

A stored procedure is a prepared SQL code that one can save, so the code can be reused over and over again.

So if we have an SQL query that we can write over and over again, save it's a stored procedure, and then just call it to execute it.

You can also pass parameters to a stored procedure, so that the stored procedure can act based on the parameter value(s) that is passed.

CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

Answer 2

A stored procedure is a piece of prepared SQL code that you can save and reuse over and over.

So, if you have a SQL query that you create frequently, save it as a stored procedure and then call it to run it.

You can also pass parameters to a stored procedure so that it can act based on the value(s) of the parameter(s) passed.