What is the difference between a Stored procedure and function?
- 9 Answers
- 12282 Views
- I also Faced
- E-Mail Answers
Answer Posted / viren chakraborty
a stored procedure is better when returning one or more
rows.
a function is better when returning a single scalar value.
function and procedure, both can accept parameters and both
also support output parameters.
for programmers, stored procedures are the way to go
because they directly return the result of a given select
statment.
in a function you will explicitly have to return a value
using return statement and returning more than 1 value
using a function is much more complicated.
the procedure is capable of doing all kinds of things
(select/insert/update/delete) and hence, it is better
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Name the tools or API for developing or testing web api?
Define application state variable and session state variable?
What is full form of asp.net?
What is the difference between globalization and localization?
How can we create a website?
How to disable cut, copy and paste in TextBox using jQuery in asp.net?
Is there any alternative to avoid name collisions other then Namespaces?
What is a postback in asp net?
What do you mean by serialize and marshalbyref?
What is globalization and localization in asp net?
What is special types forms
How does session work in asp net?
What is viewstate? What does the "enableviewstate” property do? Whay would I want it on or off?
What are server objects?
What can you do with asp.net?
