Stored-procedures and its advantages

Question

Explain about the stored-procedures and its advantages.

Answer 1

Stored procedures are database objects which perform a user defined operation.

Well a stored procedure can contain a set of compound SQL statements. It executes the SQL commands and returns the product to the client. All stored procedures are utilized to decrease network traffic.