Stored procedures manage, control and validate data.

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.