Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Stored procedure and function?
- 9 Answers
- 13910 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
What is diff. Between abstract class and an interface?
What is Dynamic Web and discuss its usage with the help of real life examples?
Is react a template engine?
What is difference between session and cookies?
What is enableviewstate in asp net?
Let's say I have an existing application written using vb6 and this application utilizes windows 2000 com+ transaction services. How would you approach migrating this application to.net?
When was asp.net released?
Do you know caching feature?
Explain how is a property designated as read-only?
How to store checkbox value in database in asp.net mvc? : Asp.Net MVC
1.what is the application pool. 2.what is the HttpModile and Http Handler. 3.C# 3.0 Features ? 4.Anonoymous Type,methopd and claas in 3.0? 5.difference between statsic and const ? 6.session vs application 7.state management clint side and server side ? 8.Genric list 9.c# 3.0 vs 3.5
What is session in http request?
What are the security types in ASP/ASP.NET? Different Authentication modes?
How to find last error which occurred in Asp.net ?
Explain different types of validators in asp.net?
