| |
|
Stored procedure can reduced network traffic and latency, boosting application
performance. · Stored procedure execution plans can be reused, staying cached
in SQL Server's memory, reducing server overhead.
· Stored procedures help promote code reuse.
· Stored procedures can encapsulate logic. You can change stored procedure code
without affecting clients.
· Stored procedures provide better security to your data.
|
|