» 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