SQL Stored Procedures
Remarks
Stored Procedures are SQL statements stored in the database that can be executed or called in queries. Using a stored procedure allows encapsulation of complicated or frequently used logic, and improves query performance by utilizing cached query plans. They can return any value a standard query can return.
Other benefits over dynamic SQL expressions are listed on Wikipeida.
