SSRS Interview Question:

What are the advantages of using Stored Procedures?

Submitted by: Administrator

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.
Submitted by: Administrator