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

What is a recursive join sql?

1061


What is query execution plan in sql?

1177


How to combine two stored procedures in sql?

1213


Is a view faster than a stored procedure?

953


What is the difference between python and sql?

989


Write an sql query to select all records from the table?

1011


How to get unique records from a table?

955


how do you know if your mysql server is alive? : Sql dba

1073


Is it possible to create the following trigger: before or after update trigger for each row?

1277


Name three sql operations that perform a sort.

997


What are records give examples?

998


What is constant in pl sql?

1012


Which is better stored procedure or query?

955


Explain foreign key in sql?

1014


what are the types of join and explain each? : Sql dba

1030