SQL Stored Procedures

Stored Procedures is a collection of SQL statements that can executed in a single unit or function. It is used mostly for encapsulate info, and perform the same tasks multiple time.

You can specify what your procedure name, write as many sql statements that suits your needs within a stored procedure. It is like writing a method/function in SQL, but they don't return a value. its just an easier way to execute multiple sql statements into one location.

`CREATE PROCEDURE procedure_name
AS
BEGIN
    SELECT * FROM tbl_name;
    ... 
END;

EXEC procedure_name;`

You can write Stored Procedures with parameters to pass conditional values, which makes your stored procedure more flexible when quering data.

`CREATE PROCEDURE procedure_name_with_param @ParamName nvarchar(32)
AS
BEGIN
    SELECT * FROM tbl_name WHERE column_name = @ParamName;
    ... 
END;

EXEC procedure_name_with_param @ParamName='param_value';`