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 are the ado.net connection pooling parameters?

983


What are the connected and disconnected modes in ado.net?

916


Which property is used to check whether a DataReader is closed or opened?

1050


Compare Data Reader & Dataset in ado.net?

1002


Define bubbled event?

933


What is difference between ado and other data object?

913


What is an ado?

985


Explain sqlconnection object?

1005


What are the data access namespaces in .NET?

1212


What is csdl entity framework?

1022


In how many ways we can retrieve table records count? How to find the count of records in a dataset?

1011


What is the use of SqlCommandBuilder?

1208


What is linq and entity framework?

1009


What is acid in ado.net?

1038


What is meant by executenonquery?

938