Stored procedure
- Stored procedure can execute function.
- Stored procedure may or may not return value.
- Stored procedure can execute DDL Commands (Drop, Create, Alter etc.)
- Stored procedure can not be used in any SQL statement like Select/Where/Having.
- Stored procedure can use try/catch block.
- Stored procedure can use Transaction.
Function
- Function can not execute Stored procedures.
- Function always return value.
- Function can not execute DDL Commands (Drop, Create, Alter etc.)
- Function can be used in SQL statements like Select/Where/Having.
- Function can not use try/catch block.
- Function can not use Transaction.