Question

Benefits of Stored Procedures?

Answer 1

The benefits of using stored procedures in SQL Server rather than application code stored locally on client computers include:

.They allow modular programming.

.They allow faster execution.

.They can reduce network traffic.

.They can be used as a security mechanism.

I hope this helps you