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 3 major types of connection objects in ado.net?

937


What are the ado.net objects?

888


Which name space is used to get assembly details?

921


What does executenonquery () method return?

877


What are the advantages using ado.net?

979


What do you mean by ‘batch updates’?

976


What are the Features of a dataset

1181


Why edit is not possible in repeater?

896


Is bulk insert faster than insert?

858


How can we serialize the dataset object?

951


What connected data?

889


Difference between sqlcommand and sqlcommandbuilder?

1052


What is ole data type?

851


What is ole db query?

921


How to read data with the sqldatareader ?

920