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.

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...