Difference between SQL Function and Stored Procedure

The main difference between functions and stored procedures  are given bellow:
Function(User Defined)

1. It returns only one value
2. We can’t use transaction in function
3. Only have input parameter
4. We can’t called SP from function
5. We can’t use exception handling using Try-Catch block in function
6. We can use function in select/where/having statement

Stored Procedure (Store Procedure)

1. It returns zero, single or multiple values
2. We can use transaction in SP
3. Can have input/output parameter
4. We can called function from SP
5. We can use exception handling using Try-Catch block in SP
6. We can’t use SP in select/where/having statement