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 an ado?

935


Explain how to create dynamic gridview?

918


Is bulk insert faster than insert?

858


What are the Features and disadvantages of dataset

1034


Which object of ado contains datarow datacolumn collection?

892


What is a data control clerk?

978


Which is faster entity framework or ado.net?

878


What is serialization and de-serialization in .net? How can we serialize the dataset object?

906


What is difference between datareader and dataadapter?

996


Which method is used to sort the data in ADO.Net?

1918


What is the difference between DataReader and DataSet in ADO.NET?

1077


What is a serialized object?

942


What is datatable in ado.net?

921


differences between ADO and ADO.NET

1025


What are the core objects of ADO.NET?

978