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

why text area checkpoints cannot used for web applications

2322


Can any body please tell me the steps of keyword driven framework of QTP.

1908


What is Test Fusion Report in QTP?

1098


When to use shared and local object repository?

1013


Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?

1882


What are the different types of recording modes in qtp? Which will be used when?

996


What are the different ways to invoke an application using QTP?

1107


requirement is for combo box your expected value is str= "Denver.Frankfurt.London.Los Angeles.Paris.Portland.San Francisco.Seattle.Sydney.Zurich" you must get the text in combo box and need to compare them how

1945


is it possible to add sheets to excel at runtime

3946


Hi, I have 2 dropdown listboxes called region and city/area. It needs to select one region(Santa Clara) and one city/Area (Sunnyvale).So I put this in the for loop and I am storing the Items in the variable called itemname. The regions value will get changed,so I used reg expression for this regions. This is my code Browser("MLSListings.com").Page("MLSListings.com").Link("ยป County/Area").Click Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Check CheckPoint("regions") ListSize=Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetTOProperty("items count") For i = 1 To ListSize-1 Itemname =Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetItem(i+1) Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Select Itemname ................. If I run the script,I am getting the following error, Cannot identify the specified item of the regions object. Confirm that the specified item is included in the object's item collection. Any Help? Thank you, Uma

1730


what is actually contain test report? can anybody post the test report

1901


How the exception handling can be done using quicktest professional (qtp)?

1016


How to find Operating system information using QTP script?

950


What is an optional step in qtp ?

1110


What is the difference between the design-time and run-time data tables?

1069