What are differences between function and stored procedure?
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.
Truck Dispatch Software | Taxi App Development | Hire Angularjs Developers | Mobile Application Development Company | Top Mobile App Developers | iPhone App Development Company | Find Xamarin Certified Developers| peer-to-peer ridesharing| how to create a ride share app| app development companies usa | Hire Kotlin Developers
Bookmarks