What is the difference between a Stored procedure and function?
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
Explain the difference between array and linkedlist?
What is rending process in ASP.NET?
What are resource file and how do we generate resource file?
Explain the function of new view engine in asp.net? : asp.net mvc
I want to connect a system in LAN and I want to access that. Whenever I am moving a mouse in my desktop, the similar thing has to happen in another system in which I have connected. I need coding for this in C# and ASP.NET Can anyone please help me. It is very urgent. Thanks in advance. My email id is manojkumarchallagundla@gmail.com Will you please?
What are the advantages and disadvantages of session?
What is a user session?
What is autopost?
Explain repository pattern in asp.net mvc? : asp.net mvc
What symbol specifies the beginning of a query string?
What is the difference between visual basic and asp.net?
Does asp.net still recognize the global.asa file?
Which method is used to perform all validation at the page level?
Explain parts of assembly?
What are uri parameters?