» SQL Stored Procedure
SQL Stored Procedure Tutorial
Stored procedure by definition is a segment of code which contains declarative or procedural SQL statement.
You will learn how to write the first stored procedure and how to call it.
A stored procedure can have zero, one or more than one parameters. If a stored procedure has more than one parameter, each one must be separated by a comma.
The body part of a stored procedure is where you can put your business logic code inside to execute it as you want it to do.
Local variables are used in stored procedure to keep temporary intermediate results.
There are two most common usage of flow-control which are conditional execution and loop.
Once a store procedure is resided in the database server catalog, we can modify it by using the ALTER PROCEDURE statement or remove it by using DROP PROCEDURE