Stored Procedures are Precompiled
means SQL Server compiles each Stored Procedure once and then re
utilizes the execution plan. This results in great performance improvements
when Stored Procedures are called frequently. It Reduced load on the network
bandwidth. Stored Procedures can be used by multiple users and client programs.
If you utilize them in a planned manner then you'll find the development cycle
requires less time. You can grant users permission to execute a Stored
Procedure independently of underlying table permissions.
