Function Procedure
The function returns the single value which is anyhow mandatory. The procedure returns zero or N values.
They only work with a statement: Select They can work with multiple statements: Insert, Update, Delete, Select.
In function, transactions are not possible In the procedure, transactions are possible
Error handling is not possible With try-catch, error handling is possible.
BY Best Interview Question ON 09 Jan 2021