Stored Procedure and Function

Stored procedure	Function
A procedure need not return a value	Function must return a value
Returns values using out parameters	Function returns values using return expression
They supports optional parameters	they does not support optional parameters
You can call a function from stored procedure	You cannot call a stored procedure from a function
Procedure can’t be called in select statement	Function can be called in select statement
Try and catch statements can be used	Try and catch statements cannot be used.