Answer / santosh(ssit)

Both functions and procedures can return values. Apart from
this following are the differences

1) Functions are used for computations where as procedures
can be used for performing business logic

2) Functions MUST return a value, procedures need not be.

3) You can have DML(insert,update, delete) statements in a
function. But, you cannot call such a function in a SQL query..
eg: suppose, if u have a function that is updating a table..
you can't call that function in any sql query.
- select myFunction(field) from sometable; will throw error.

4) Function parameters are always IN, no OUT is possible

5) Function returns 1 value only. procedure can return
multiple values(max. 1024)

6) Stored Procedure :supports deffered name resoultion
Example while writing a stored procedure that uses table
named tabl1 and tabl2 etc..but actually not exists in
database is allowed only in during creation but runtime
throws error Function wont support deffered name resolution.
Stored procedure returns always integer value by default
zero. where as function return type could be
scalar or table or table values(SQL Server).
Stored procedure is pre compiled exuction plan where as
functions are not.

7) A procedure may modifiy an object where a function can
only return a value.

Answer / 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.

Answer / 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.

Answer / savi

1.fumction should return a value
procedure may or not return a value
2.function computes a value
procedure performs an action

Answer / babu

1.Function always return a single value but procedure may
return more than one value.
2.We can use functions in select statement but we can not
use procedure in select statement.
3.There is possible of recurssive functionlike max(min
(something)),but there is nothing like in procedure.
4.In function we use a return keyword but in procedure no
return keyword is used.

Answer / xyz

manohar evaru picchi lanza koduku..procedure ki function ku
answer ala icchadu..professional va kaaada ra pukaa.

Answer / abhishek khare

1.Funcan can return a valur but not procedure
2.Function can accept only one parameter IN but procedure
can take IN or OUT or both parameters.
3.Procedure follows only linear execution but not function.

Answer / siva

Fuction returns a value whereas procedure doesnt return any
value
if some function calling is dere den function switch over 2
d function definition part directly but procedure go from
top 2 down linearly

Answer / deepika

Action is a part of Function.
Function is a Like a Functional Test case.
Procedure is a process to perform the Different Actions

Answer / vinod

All are correct....

How to call Datable values in the QTP program. exp: I have two parameters like Email id and Password this two i would like to add multiple entries in the datable to use it. What is the difference between Gobal/Action datatable

3 Answers  

Hi, one script having 10 Actions,but i want to execute only 3rd action and 7th action? how to execute selected actions? throgh script and through navigation?

2 Answers   IBM,

Gmail application is there.On that Inbox so many mails are there including naukari mails. On that mails i can select the only naukri mail checkboxes. plz tell the descriptive code for the above..

2 Answers   Impetus,

When to use shared and local object repository?

0 Answers  

How do you change Logical Name of the object in test script?

1 Answers   TCS,

What are the technics follow in writing VB script?

0 Answers   CTS,

Define object spy ?

0 Answers  

How can I test the unix shell in QTP

2 Answers   Persistent,

Where can I find and view run-time data table?

0 Answers  

I have 5 save buttons in my application on 5 different tabs one after the another . I have spy them and added each of them in my OR. My Or is able to highlight each button on each of the 5 tabs. But when I run the script it does not click the object.Is there anything I have to edit in OR. Any property to add or delete? Below are the properties of 5 save buttons. My code for each is like browser().page().savebutton1.click Browser().page.savebutton2.click Properties of 5 buttons Dhopare, Namita Sent: September 2, 2015 2:57 PM To: Vullengala, Jagadeeshchandra "Class Name:=WebButton", "abs_x:=718", "abs_y:=693", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSaveTab1", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSaveTab1"" class=""Button"" onclick=""document.getElementById('a1').click();"" name=""btnSaveTab1"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=718", "y:=616" "Class Name:=WebButton", "abs_x:=687", "abs_y:=571", "class:=Button", "disabled:=0", "height:=22", "html id:=btnSave", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""btnSave"" class=""Button"" onclick=""document.getElementById('a2').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=687", "y:=494" "Class Name:=WebButton", "abs_x:=635", "abs_y:=478", "class:=Button", "disabled:=0", "height:=23", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a3').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=635", "y:=401" "Class Name:=WebButton", "abs_x:=695", "abs_y:=558", "class:=Button", "disabled:=0", "height:=22", "html id:=BtnExternalPartySve", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input id=""BtnExternalPartySve"" class=""Button"" onclick=""document.getElementById('a4').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=41", "x:=695", "y:=481" "Class Name:=WebButton", "abs_x:=672", "abs_y:=642", "class:=Button", "disabled:=0", "height:=22", "html id:=", "html tag:=INPUT", "innerhtml:=", "innertext:=", "name:=Save", "outerhtml:=<input class=""Button"" onclick=""document.getElementById('a5').click();"" value=""Save"" type=""button"">", "outertext:=", "type:=button", "value:=Save", "visible:=True", "width:=40", "x:=672", "y:=565" Previous Item Next Item Connected to Microsoft Exchange

1 Answers  

Hi All, I am using QTP for one of the Desktop application which uses Keyboard inputs like 'Tab ,F7 etc' and also mouse (Click). After recording when i am running the Script ,it is not able to recognize the keyboard inputs like F7,Tab and mouse Click because of which either i have to skip that part or manually do the inputs. Please answer how can i make script more flexible so that it will recognize both keyboard and mouse operations.

3 Answers  

why is execute file used.

1 Answers   Deloitte,