| Function | Stored Procedure |
|---|---|
| Can only return one value | Can return any number of values |
| No support for exception handling using try-catch blocks | Supports the usage of try-catch blocks for exception handling |
| The argument consists of only one input parameter | Both input and output parameters are present |
| A function can be called from a stored procedure | The stored procedure cannot be called from a function |
