A stored procedure is an already written SQL statement that is saved in the database. We can run the stored procedure from the database's command environment.
1. Precompiled execution. SQL Server compiles each stored procedure once and then reutilizes the execution plan. This results in tremendous performance boosts when stored procedures are called repeatedly.
2. Reduced client/server traffic. If network bandwidth is a concern in your environment, you'll be happy to learn that stored procedures can reduce long SQL queries to a single line that is transmitted over the wire.
3. Efficient reuse of code and programming abstraction. Stored procedures can be used by multiple users and client programs. If you utilize them in a planned manner, you'll find the development cycle takes less time.
4. Enhanced security controls. You can grant users permission to execute a stored procedure independently of underlying table permissions.
0 comments:
Post a Comment