Differentiate between stored procedure and functions?

There are several differences between stored procedures and functions. These are: -

• Stored Procedure is very suitable to perform business logic while functions are utilized to do the calculation.
• Stored Procedure need not hold the return type while Function obligates the return type.
• A stored procedure can be returned 0 or more values while a function may state just one value.
• The Stored procedure upholds input and output parameters while the function upholds only input parameter.
• The stored procedure may be used try/catch for exception handling but it is not be used in a function.