SQL Server Reporting Services Question: Download SSRS PDF
Describe the purposes and advantages stored procedure?
Answer:
Stored procedures manage, control and validate data.
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.
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 are the advantages of using Stored Procedures? | What is RAID (Redundant Array of Inexpensive disks)? Explain its level? |