SQL Stored Procedures Question: Download MS SQL Stored Procedures PDF
What are the purposes and advantages stored procedure?
Answer:
Purposes and advantages of stored procedures:
Manage, control and validate data
It can also be used for access mechanisms
Large queries can be avoided
Reduces network traffic since they need not be recompiled
Even though the stored procedure itself may be a complex piece of code, we need not write it over and over again. Hence stored procedures increases reusability of code
Permissions can be granted for stored procedures. Hence, increases security.
Manage, control and validate data
It can also be used for access mechanisms
Large queries can be avoided
Reduces network traffic since they need not be recompiled
Even though the stored procedure itself may be a complex piece of code, we need not write it over and over again. Hence stored procedures increases reusability of code
Permissions can be granted for stored procedures. Hence, increases security.
| Previous Question | Next Question |
| What is extended Stored Procedures? | Determine when to use stored procedure to complete SQL Server tasks? |