What is Stored Procedures in SQL Server?

Stored procedures encapsulate SQL operations behind a named database routine. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.