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...

Differnce between Stored procedure and user defined functions?

Answer Posted / shivendra pandey

stored procedure is precomplied and not return value by
default but function compile each time and use return
statement simply.
if u r using database then use stored procedure for
pefmance n if u are working with simple pl for some
calculation go for function

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is serialization and de-serialization in .net?

913


How can we serialize the dataset object?

989


What are the key events of sqlconnection class?

1178


What are the advantages using ado.net?

1024


What is a dynaset in access?

1054


What is ambient transaction?

936


What is the difference between ado.net and entity framework?

1038


What is executequery?

940


What is ole word?

940


What is connected architecture in ado.net?

1048


Define executenonquery?

903


What is difference between executequery and executeupdate?

980


Describe ado.net object model in detail.

982


What do you mean by performing asynchronous operation using command object?

1024


Explain executenonquery?

1123