Many system architects choose to use SQL Server stored procedures as part of their application designs, especially when a SQL Server is already being considered for data storage, because stored procedures provide centralized management of the SQL code, encapsulate all access to the data for performance tuning, and allow detailed security control. Stored procedures can be used for data retrieval, selection (to a given criteria), and manipulation.
Here are a few of the many advantages of using SQL Server stored procedures:
Central control of SQL code
Optimal speed for data operations
Data access control
Data selection and manipulation procedures common to all client applications