Answer:
Stored procedures are often used for data validation and as access control mechanism. Logic applied in applications can be centralized and stored in applications. Complex procedures and functionalities which require huge amount of data processing and logic implementation access their data by procedures. Data is stored in these procedures and accessed by procedures.
| Previous Question | Next Question |
| What is a stored procedure? | What is the difference between a user defined function and a Stored procedure? |