SQL Server Reporting Services Question:
Download Questions 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.

Download SSRS Interview Questions And Answers PDF

Previous QuestionNext Question
What are the advantages of using Stored Procedures?What is RAID (Redundant Array of Inexpensive disks)? Explain its level?