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 jayaraman

Procedure-is also called Proc

proc-parsing resloving organizing compiling

stored Procedure once compiled and run many times,when we
create procedure,that procedure is stored in executeplan,so
no need to recompile.

but fuction every time compiling and running.

Is This Answer Correct ?    21 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between dataset and datatable?

1000


What is the use of SqlCommand object?

1220


What is a sqldataadapter?

989


What is oledb driver?

930


Explain how to find the given query is optimised one or not?

1019


What is ado and rdo?

899


What are the features of ado.net?

1028


How will you fill the gridview by using datatable object at runtime?

1041


What is data relation in ado.net?

1062


What is an example of ordinal data?

1128


How can we load multiple tables in to dataset?

1083


Is bulk insert faster than insert?

905


What is a column variable?

933


What is ado rdo dao in visual basic?

1164


Describe the disconnected architecture of ADO.NET’s data access model.

1055