Stored procedures are collections of SQL statements and optional control-of-flow statements.
Stored procedures can use parameters to accept values and return values to the calling environment. Stored procedures can return result sets to the caller or call other procedures.