What is difference between function and procedure?

Answer Posted / priya

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

How to build scripts that access data from external sources?

1598


How to call a test from another test?

674


Does QTP run in any environment?

603


hi, FOR 3+ QTP INTERVIEW, FOR EXAMPLE WE PUT ONLINE BANKING SYSTEM PROJECT IN OUR RESUME, IN PROJECT MANAGER ROUND...WHAT R THE MAJOR QUESTIONS ARE ASKED IN P.M? PLS TELL ME ATLEAST 10 QUESTIONS?.....AND IF POSSIBLE POST ANSWERS ALSO....

2423


how to find that a file has been completely downloaded or not? I told that "download Complete" pop up. but he told the tool doesn't recognize the pop up

3745






How to use reporter.report event in qtp ?

545


What is quick test pro?

582


Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project

1630


What is CMMP and CMMH?

690


Explain the concept of object repository?

521


How to change the priorities of the recovery scenario properties?

587


how can we compare descriptive programing with a regular expression

1912


What is the recovery scenario in qtp?

562


Where to use Property Let, Property Get, Property Set in UFT

368


What processes will be required to manage updates to the web site's content, and what are the requirements for maintaining, tracking, and controlling page content, graphics, links, etc.?

596