What are differences between function and stored procedure?
Printable View
What are differences between function and stored procedure?
Function returns only one value but procedure returns one or more than one value.
Function it must return value,it will allow only selected elements,not allow us to try-catch block,transaction not allow within function,functions can be called from select statement,transaction not allowed within the function.
Stored procedure not return any value someone return value for exception handling you can use try catch block procedure not use any select statement we can use call/execute
the stored procedure.
Basic Difference. Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values). Functions can have only input parameters for it whereas Procedures can have input/output parameters . Functions can be called from Procedure whereas Procedures cannot be called from Function.
Function must return a value but in Stored Procedure it is optional
Capacity must restore an esteem however in Stored Procedure it is discretionary( Procedure can return zero or n esteems). Capacities can have just info parameters for it though Procedures can have input/yield parameters . Capacities can be called from Procedure though Procedures can't be called from Function.