Editing Stored procedure (section)

== Comparison with functions ==
* A function is a subprogram written to perform certain computations.
* A scalar function returns only one value (or NULL), whereas a table function returns a (relational) table comprising zero or more rows, each row with one or more columns.
* Functions must return a value (using the <code>RETURN</code> keyword), but for stored procedures this is not mandatory.
* Stored procedures can use <code>RETURN</code> keyword but with no value being passed.
* Functions could be used in <code>SELECT</code> statements, provided they do no data manipulation. However, procedures cannot be included in <code>SELECT</code> statements.
* A stored procedure can return multiple values using the <code>OUT</code> parameter, or return no value.
* A stored procedure saves the query compiling time.
* A stored procedure is a [[database object]].
* A stored procedure is a material object.