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.
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 Question | Next Question |
What happens when my integer IDENTITY runs out of scope? | Describe the purposes and advantages stored procedure? |