Stored Procedure is a function which contain collection of SQL Queries. Procedure can take inputs , process them and send back output.
Stored Procedures are pre-complied and stored in database. This enable the database to execute the queries much faster. Since many queries can be included in a stored procedure, round trip time to execute multiple queries from source code to database and back is avoided.