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 function and procedure?

Answer Posted / sardar tariq

A FUNCTION is always returns a value using the return statement.
A PROCEDURE may return one or more values through parameters or may not return at all.
-Function is mainly used in the case where it must return a value. Where as a procedure may or may not return a value or may return more than one value using the OUT parameter.
-Function can be called from SQL statements where as procedure can not be called from the sql statements.
-Functions are normally used for computations where as procedures are normally used for executing business logic.
-You can have DML (insert,update, delete) statements in a function. But, you cannot call such a function in a SQL query.
-nction returns 1 value only. Procedure can return multiple values (max 1024)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which scripting language used by quicktest professional (qtp)?

1185


what is supply chain management?

2645


I want to know can we integrate visual source safe tool with QTP and QC for our version controlling process? WE know QTP and QC 10.0 version is having the version control inbuilt in it but I want to know the merits and demerits of the inbuilt version control tool and the visual source safe tool using QTP and QC.

3097


Hi,All How to create a link in excel sheet using qtp

3490


How to create Reusable and Multiple Actions?

2237


How will internal and external links be validated and updated? how often?

1165


How do you convert manual test cases to automated test cases?

1152


how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance

1961


how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page

2415


I want to configure the OR and library files to a particular QTP test during run time. Note: OR and Library files are located in Quality Center. Is it possible in QTP? Anybody having code?

1887


images are dynamically changes how to compare two images with out using the bitmap

2459


How to use setroproperty?

1080


What is the use of Debug Viewer?

1985


Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?

1051


what is the hierarchy to use properties in descriptive programming

2038