A stored procedure in SQL Server is a group of one or more Transact-SQL statements

Sequence of SQL queries stored in the database. Advantages of being pre-compiled, transaction control, and readability. Downside being database dependent.