When to use a Stored Procedure
Use a stored procedure to move repetitive tasks and calculations done on the data closer to the actual database. Because the stored procedure is stored on the server machine where the database is located, you gain the following benefits:
• Performance is improved.
• Business logic can be encapsulated onto one machine (the server), instead of being distributed to multiple client machines.
• Greater security is achieved.
Last modified date: 01/29/2015