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 the difference between connected and disconnected environment?

1105


What are the methods of XML dataset object?

1026


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

2378


Do you use stored procedure in ado.net?

1028


What is ado and rdo?

901


Define bubbled event?

928


How to add a javaScript function in a datagrid?

1132


What is aggregating data ?

960


What is ado.net objects?

965


What is csdl entity framework?

1020


Explain the namespaces in which .net has the data functionality class.

1085


Why is stored procedure used in ado.net?

1118


What is the use of SqlCommandBuilder?

1206


How to check if the Dataset has records ?

1008


What are the data providers used in ado.net

1019