securty & less execution time

http://www.seguetech.com/blog/06/04/Advantage-drawbacks-stored-procedures-processing-data

Execution plan retention and reuse Encapsulation of business rules and policies S haring of application logic between applications Access to database objects that is both secure and uniform Consistent, safe data modification Network bandwidth conservation Improved security Reduced development cost and increased reliability Centralized security, administration, and maintenance for common routines.