What are stored-procedures? And what are the advantages of using them.

Stored procedures are database objects that perform a user defined operation. A stored procedure can have a set of compound SQL statements.
A stored procedure executes the SQL commands and returns the result to the client. Stored procedures are used to reduce network traffic.