What is difference between function and procedure?

Answer Posted / nafaji

1. Function can return only one value but procedure can return more than one, or may not return any value.

2. Function can be called from sql statements where as procedure cannot be called from the sql statements.

3. We can use functions in select statement but we can not use procedure in select statement.

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i want information about API testing and i want info like how process can be done in company? i want added info like coding ,debugging, desing in c.v ? what should add in c.v for eg banking domin? pls any answer my question?

1594


Should have experience in framework means?

1407


what is meant by function library?Public and private functions in function library? if private functions are applicable for only for the particular test means then y we have to add those to function library?

1360


How do you send email with attachment from outlook using qtp ?

557


How many ways we can parameterize data in quicktest professional?

546






How to replay a script in qtp?

602


What is Port testing. Whhen will you perform?

1485


how do you parameterize search button from the website? the page is a single winobject and i have made a virtual object button of search button but search box can't be converted into a winedit and if we try to convert it into winedit the value we enter in a searchbox appears as numbers in the script so we arent able to parameterize.help!!!

1718


Is the qtp course will help to create a virtual object?

1504


What is qtpro? What is quick test pro? What is a quick test professional?

578


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

1994


how to test load test and block box testing an a web based application pls give ans briefly

1345


explain how to write vb script in qtp?when will you write own script?

1845


can i change the runtime properties of an object ? How can i check if a parameter exists in database ?

1403


how can you do retesting (datadriven test) using notepad amd by using functions NOTE u should not use datatable methods

1368