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

What is connection string?

966


describe the dataset object in ado.net.

923


Give an example that shows how to execute a stored procedure in ado.net?

1033


How can we perform transactions in .net?

1015


What is ambient transaction?

903


What is the return type of executescalar?

951


What are different layers of ADO.Net?

1057


Which keyword is used to accept variable number of parameters?

1080


What does ado stand for?

875


how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....

4391


What is ado.net and its features?

938


What is ole used for?

902


What is the executescalar method?

1044


Which database is the ado.net?

933


What are the benefits of using of ADO.NET in .NET 4.0?

1007