Stored Procedure

A group of Transact-SQL statements compiled into a single execution plan.

Stored procedures are stored in the SQL database and executed upon request - through database triggers or calls from an application.