- What is the difference between a function and a procedure?
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 For a Function it is mandatory to take one input parameter, but a Stored Procedure may take 0 to n input parameters
|