A Stored Procedure is a SQL statement stored in a SQL Server database. They can be triggered with a short “EXECUTE” statement. Common functions of stored procedures include retrieving, modifying and deleting data. They are typically designed to accept one or more input parameters. This means a single Stored Procedure can be used by several people using different input data. This makes them very flexible.

Because Stored Procedures reside in a central database, when they are modified, all users automatically get access to the new version. This makes the management and standardisation of T-SQL code much easier.

Stored procedures can also reduce network traffic and improve query performance. This video tutorial provides an introduction to Stored Procedures in Microsoft SQL Server.

Download Code for Stored Procedure Tutorial