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...

What is the difference between a Stored procedure and function?

Answer Posted / madhavi latha

stored procedute can return only one integer value.while
function can return more than one value.

we can not use select statement with storedprocedures like
select <spname> where as UDF can.

storedprocedures can not return tables.where as UDF can
return more than one tables.

we can use functions inside the stored procedure but in UDF
we can not use storedprocedures.

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is application variable in asp.net?

916


what is AutoEventWireUp and what is the use of This property explain in details?

1588


Can you explain how ASP.NET application life cycle and page life cycle events fire?

1014


Is asp.net different from asp? If yes, explain how?

1024


Suppose you want an asp.net function (client side) executed on the mouseover event of a button. Where do you add an event handler?

1026


What is the benefit of WebAPI over WCF?

1002


how to debug web services on consumer side?

1051


What is the current version of asp.net?

1002


Describe briefly what is the role of IIS on an ASP.NET application? What does it for the same application?

1074


What is the procedure to create the environment for asp.net? : asp.net mvc

1037


Is it possible to write code in many languages in one asp.net project?

1018


Explain client side state management system.

969


What is the recommended approach for asp.net mvc to globally intercept exceptions? What other functionality can be implemented with the approach? : Asp.Net MVC

949


Difference between overriding and overloading?

1258


What is the significance of ASP.NET routing?

1072