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 / suresh mandala

1>Stored Procedure returns morethan one value where as
Function returns only one value
2>stored procedure we may use return statement.. but in
userdefined function we should use return statement
3>stored procedure is precomplied but function compile each
time we call it.

If u have any quieries ask me ,i will try

Is This Answer Correct ?    17 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference in record set and dataset?

1077


What are the usages of the command object in ado.net?

1024


How do you update database through dataset?

985


Why edit is not possible in repeater?

951


List the 4 common ado.net namespaces?

1170


What are the steps you will take to improve performance?

894


What is ado.net architecture?

929


What is command class in ado.net?

1028


What is ado.net connection?

962


What are the namespaces used in ado.net for data access?

984


Compare Data Reader & Dataset in ado.net?

1001


What two types of data providers does ADO.NET supply? What determines which one you should use?

990


What is difference between Dataview and Datatable?

1069


What is the role of clr?

948


Explain ado.net features?

1050