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 difference between a PROCEDURE & FUNCTION ?

Answer Posted / surajit pathak

We can use in,inout,out parameters in functions also.
The most important difference is we can use functions in
normal sql queries if it is not containing any out
parameters.
but we cann't use procedures in sql queries....

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many times can we commit in a loop?

956


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

945


What is a database event trigger?

1081


What is meant by temporal data?

905


How do you update a value in sql?

985


When should I use nosql database?

944


What does the file extension accdb stand for?

916


Why is the cursor important?

977


What is a dynamic query?

971


Which normal form is best?

895


What is the difference between clustered and non-clustered index in sql?

957


What is sql rowcount?

949


What are the two types of cursors in pl sql?

1001


what are the disadvantages of mysql? : Sql dba

1075


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3945