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 / shivendra pandey

stored procedure is precomplied and not return value by
default but function compile each time and use return
statement simply.
if u r using database then use stored procedure for
pefmance n if u are working with simple pl for some
calculation go for function

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oledb connection?

942


Explain sqlconnection object?

943


Is ado.net dead?

958


What are all the different authentication techniques used to connect to MS SQL Server?

1020


What is ado and rdo?

868


What is bubbled event?

922


Explain what are acid properties?

929


What are the key features of ado.net?

1139


What is ado.net and its architecture?

1086


What is data reader in ado.net?

962


What is Serialization in .NET? what are the types of Serialization?

1035


Does entity framework use ado.net?

935


What is the return type of executescalar?

943


What is openrowset?

926


Which namespaces are used for data access?

1133