Stored procedures are specialised programs stored in RDBMS. A stored procedure is a named group of SQL statements (and in some cases operating system calls) that have been coded and stored directly in a database.
Stored procedures provide the following advantages:
1) Reduced network traffic
2) Improved performance of server-intensive work
3) Separation and reuse of business logic
4) Access to server features
Thursday, June 18, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment