Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Stored procedure and function?
- 9 Answers
- 13491 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
Explain global assembly cache.
Is a dll file an executable?
Where you store Connection string in "Web.Config" file in ASP.NET?
Explain the use of errorprovider control in .net?
Can you use c# without .net?
How do active server pages work?
Can we use a static function with a non-static variable?
Explain form level validation and field level validation?
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 is the difference between user control and custom control?
What are the two properties that are common on every validation control?
What are the different web pages?
What is query string? What are its advantages and limitations?
What is the meaning of TestApi?
What is the significance of ASP.NET routing?
