1. They help in reducing the network traffic and latency which in turn boosts application performance.
2. They help in promoting code reuse.
3. They provide better security to data.
4. It is possible to encapsulate the logic using stored procedures. This allows to change stored procedure code without affecting clients.
5. It is possible to reuse stored procedure execution plans, which are cached in SQL Server's memory. This reduces server overhead.
2. They help in promoting code reuse.
3. They provide better security to data.
4. It is possible to encapsulate the logic using stored procedures. This allows to change stored procedure code without affecting clients.
5. It is possible to reuse stored procedure execution plans, which are cached in SQL Server's memory. This reduces server overhead.
No comments:
Post a Comment