A stored procedure is simply a procedure that is stored on the database server. Usually written in SQL, the stored procedure benefits from the power and proximity of the database from which it is managed.
What are the benefits of using Stored Procedures?
1. Encapsulate application logic
2. Enable controlled access to database objects
3. Reduce network traffic
4. Alleviate the processing load on the client
5. Allow faster, more efficient execution Interoperability of logic implementations
What are different types of stored procedures?
No comments:
Post a Comment