Stored Procedure

• The Stored procedure is actually a piece of code that can be saved in order to reuse it and saves a lot of time instead of writing the queries over and over again.

• Depending on the need , SQL stored procedure can also use parameters as Input and Output.

• It is a secure place to write your code , for instance : A stored procedure can be encrypted which secures it from unauthorized access.

• Permissions can be given to only particular users to access the stored procedure to have a better control of security .

• When a stored procedure is executed  , it gets stored in the cache memory which increases performance and efficiency.

• They are executed after writing execute statement.

• Better error handling can be done in the stored procedure.

• 6. Programmable Objects