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

diffrence between function and procedure

Answer Posted / srinivas k

Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

920


What is trigger explain with program?

963


Is it possible to update the views? If yes, how, if not, why?

1004


What are orphan records?

916


What is PROJECTION Operation?

1004


Tell me what is difference between view and materialized view?

918


How to rename an existing column with sql server management studio?

982


What is co-related sub query?

1005


What is temporal data type?

902


Explain about system database?

1044


What is query parameter in ssrs?

160


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

938


How can sql server instances be hidden? : sql server security

1117


What is TDS(Tabular Data Stream) Gateway?

121


Explain syntax for viewing trigger?

903