SQL Server Reporting Services Question: Download SSRS 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.
| Previous Question | Next Question |
| What happens when my integer IDENTITY runs out of scope? | Describe the purposes and advantages stored procedure? |