Advantages of using Stored Procedures in Application Development

Advantages of using Stored Procedures in Application Development

  1. Application Modularization
  2. Encapsulation of Business Rules and Policies
  3. Access to database objects is both secure & uniform
  4. Network bandwidth conservation
  5. Execution plan retention and reuse
  6. Reduced development cost and increased reliability
  7. Enables sharing of application logic between application
  8. Query Auto-parameterization
  9. Consistent and Safe Data Modificatio