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 the advantage of ado.net?

1060


Do we use stored procedure in ADO.Net?

1052


What are the data access namespaces in .NET?

1257


How do you implement locking concept for dataset?

1041


What is isolation?

1072


What is dataset and datatable in ado.net?

1040


What is commandbuilder in ado.net?

1095


What are basic methods of dataadapter?

1011


What are typed and untyped dataset?

1147


What is difference between dataset and datatable?

1260


What is the full form of ado?

1083


How to create data relations?

1048


Define ado.net?

1182


What are the rules to implement connection pooling?

1117


Explain which name space is used to get assembly details?

1018