Difference Between Stored Procedure and Function
The function must return a value but in Stored Procedure it is optional. Even a procedure can return zero or n values. Functions can have only input parameters for it whereas Procedures can have input or output parameters. Functions can be called from Procedure whereas Procedures cannot be called from a Function.
What is difference between function and procedure?A procedure is used to perform certain task in order. A function can be called by a procedure.