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

How many languages are supported by .NET at present time?

729


What is the difference between “Web.config” and “Machine.Config”?

1092


What is full trust in asp.net?

1021


What are Master Pages in ASP.NET? or What is a Master Page?

1062


How many types of sessions in asp.net?

1067


What does occur first in ASP.Net, Authentication or Authorization?

994


What are custom controls?

888


What is the question mark in a url?

899


What is a Cookie? Where is it used in ASP.NET?

1040


How many types of cache are there?

928


What are the differences between the response.write() and response.output.write()?

969


Explain server-side scripting and client-side scripting.

864


Can more than one person use the same login?

928


Does web services support data reader like pom project?

880


What are the properties of the eventargs argument when capturing keyboard events?

1028