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 / sivacharan svs

Funtion Should Return a value
Procedure may or may not return a value
Function can be used in Your Select Quries
Procedure has to be passed with or with out parameters
Select Getdate() as date
Function returns date time here


The resultant value of the stored procedure can be used in
application where as the resultant value of the stored
procedure is used in a query.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add a check box or a dropdown list to a column in a datagrid?

964


What is sqldatasource?

924


What is bubbled event can you please explain?

1030


Is ado.net dead?

1002


How to retrieve the user id which is provided while windows authentication?

1091


How can we serialize the dataset object?

991


What is the use of ADO.NET and XML web services?

1038


What is partial class?

969


What is two way data binding android?

980


What are the different ado.net namespaces?

1051


Explain sqlconnection object?

991


What is ado connection?

942


What is the difference in record set and dataset?

1024


differences between ADO and ADO.NET

1065


What is the difference between the clone() and copy() methods of the dataset class?

1075