Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the modes of updation in an updatepanel? What are triggers of an updatepanel?

982


What is the use of express session?

975


How would you get asp.net running in apache web servers?

1018


How to store checkbox value in database in asp.net mvc? : Asp.Net MVC

969


What is the flow of processing of the request? : asp.net mvc

1023


Is session server side or client side?

949


Is session stored in browser?

966


Explain how can we inherit a static member?

975


Asp pages that worked pefectly on windows 2000 server and iis 5.0 do not work on windows 2003 server with iis 6.0. Asp.net pages work fine. Why?

979


Why asp.net is used?

1013


Explain About duration in caching technique

1057


Describe session handling in a webfarm?

991


How do I debug an asp.net application that was not written with visual studio.net and that does not use code-behind?

999


Define authentication and authorization.

1076


Which is the parent class of the ASP.NET server control?

1055