SQL Stored Procedures Interview Question:

What are the purposes and advantages stored procedure?

Submitted by: Administrator

Purposes and advantages of stored procedures:

Manage, control and validate data
It can also be used for access mechanisms
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.
Submitted by: Administrator