What is difference between function and procedure?

Answer Posted / priya.

Procedures v/s functions.
1.A function MUST return a value. A procedure can also
return value, but it is NOT MANDATORY for Procedure to
return a value.
2.A function can return only ONE value. A procedure can
return MULTIPLE values.
3.A function can be used with SELECT statements as like as
other in-build functions. But, a procedure cannot be used
with SELECT statements.
4.A function cannot be executed directly from SQL prompt
using EXEC command, but it is possible to execute directly
from SQL prompt using EXEC command.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

which type of testing process are you following in ur company? how to recognize a qtp page?

1397


Explain the types of object repositorys in qtp?

565


what r the main attributes of test automation?

1471


i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

1494


how to test Web application using QTP software

1328






Write a QTP script to enter a keyword in to Google search engine?

648


What is checkpoints for quicktest professional (qtp)?

568


How does qtp identify objects in the application?

577


before launching qtp, we need to close all the open browsers u dont know what are all the browsers either it might be ie,mozilla etc and u dont know how many brosers are open.... u need to close all these before launching qtp.. can anyone plz temme d solution...

7208


What is the use of sendkeys and what are send keys

1943


how to i add the values using the check points property?( i.e valid data(for valid data it's giving the footer message:value is added) and for invalid data: special chars, spaces,Duplicates and null values (in my page when ever we enter special chars, spaces and null values, it's giving the proper warning message and for Duplicates it's giving the footer message:"value already exists)?

1409


Can QTP be used for GUI testing ?, We are using Java with MySQL and Operating system is Linux. We are NOT using the web.

1940


i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com

1454


What is a checkpoint? How many check points are there in qtp?

518


To which environments does quicktest professional supports?

533