SQL Server Reporting Services Question:
Download Questions PDF

What are the advantages of using Stored Procedures?

Answer:

Stored procedures provide performance benefits through local storage, precompiling the code, and caching.

Stored procedures offers security features that includes encryption and privilege limits that restrict users from modifying structure of stored procedure.

Download SSRS Interview Questions And Answers PDF

Previous QuestionNext Question
What happens when my integer IDENTITY runs out of scope?Describe the purposes and advantages stored procedure?