PDA

View Full Version : What are differences between function and stored procedure?



Shivangi Panwar
05-08-2016, 09:33 PM
What are differences between function and stored procedure?

penrix
05-08-2016, 09:33 PM
Function returns only one value but procedure returns one or more than one value.

pxljobs
08-17-2016, 03:17 AM
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.

jeffronald19
12-19-2016, 10:27 PM
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.

ewastecompany2
06-02-2017, 03:27 AM
Function must return a value but in Stored Procedure it is optional