Question: what is difference between function and procedure explain with example?
Answer: A Function must return a value but in Stored Procedures it is optional: a procedure can return 0 or n values. Functions can have only input parameters for it, whereas procedures can have input/output parameters. ... Functions can be called from a Procedure whereas Procedures cannot be called from a Function.