Answer / rajasekhar

Procedure is used for performing a specific task any number of times in different situations,thats why it is defined as a block of reusable statements to perform a specific task..

There are 2 types of procedures
1. Function procedures
2. Sub procedures

Function procedure can return a value
Sub procedure cannot return a value


Sub procedures execute more faster than function procedures

Answer / kamal pratap singh

Difference between Functions and Stored Procedure:
1. Function always return value, but procedure may return
value or not.
2. Function return only one value, but procedure return one
value or more than one value.
3. In Function, we can insert a value through parameter
passing like IN. but in procedure, we can insert value using
IN or get a value using OUT or both insert and get value
through single parameter using INOUT.
4. Function are used to perform computation, but procedures
are used to perform business logic.
5. Function are needed to compile when they are called, but
procedures are compiled only one time, so procedures are no
need to compile again. Because the procedure are in pre
compiled format.
6. Function can be called with SQL query but procedure can
not be used with SQl query.

Answer / archana das

1> A function can only return a value ,but procedure return
multiple values (max 1024).
2> A function is normally used for computations whereas a
procedure is used for executing business logic.

Answer / d.sharath kumar

function must reaturn a value
procedure ned not be



function can take only input value,but
procedure may take both input & out put parameter

Answer / rohan

1)FUNCTION doesn't have wait statement WHERE PROCEDURE may
have wait statement..!

2)IN FUNCTION all parameters are Mode "IN" WHERE PROCEDURE
MODE may be IN,OUT,INOUT.

3)Generalize form of an expression (FUNCTION)
PROCEDURE-Generalize Form of Statsment.

Answer / veera

1) Stored procedure are compiled for first time and compiled
format is saved and executes compiled code when ever it is
called. But function is compiled and executed every time it
is called.

2) Function must return a value but in stored procedure it
is optional.

3) Function takes one input parameter it is mandatory but
stored procedure may take o to n input parameters.

4) Functions can be called from select statement, but stored
procedures can not be called from select statement.

5) We can build logic in functions and we can even break
complex logic in to methods.

6) We can use try catch statements in stored procedures but
in functions we can not use.

7) We can not use insert,delete,update and create statements
in functions but in stored procedures we can use those
statements.

8 ) Functions can have only input parameters but stored
procedure can have input and out put parameters


Thanks and Regards,
VEERA

Answer / sateesh reddy

Function must contain a return clause in the header.
Procedure do not contain a return clause in the header.

Answer / sudipta kumar dhal

1.Function is a subprogram that returns a value.

2.Procedure is a subprogram that performs a specific action.


3. Function can return only one value but procedure can return

more than one, or may not return any value.

4. Function can be called from sql statements where as

procedure cannot be called from the sql statements.

5. We can use functions in select statement but we can not use

procedure in select

6.You can have DML(insert,update, delete) statements in a
function.

7.You can have DDL(create,alter,drop) statements in a

procedure.

Answer / ankit kakadiya

correct

Answer / santosh(ssit)

1. Function returns 1 value only. Procedure can return
multiple values.
2. Function can be called from SQL statements where as
procedure can not be called from the sql statements .

What are the advantages of a Hybrid framework?

0 Answers  

write script for , launching fr window,login and create 5 elements array and store 5 order numbers inthat array? and open order by using order no.s in array and find out maximum tickets booked by which order?

1 Answers   TCS,

what is supply chain management?

0 Answers   ITC Infotech,

Hello Everyone, In QTP we have one option Data Driver wizard that comes in Tools -> Data Driver. so, please tell me abtout the use of Add Value and Parameterize options available in Data Driver wizard. And also the concept of value, constants, Parameterized displayed in the wizard. Please explain by giving the example. Thanks in advance, Gaytri

2 Answers  

Can we create a qtp test from qc?

0 Answers  

For ex we are doing automate testing in that can we do some part of application recording, some part descriptive programing and some part general VB scripting like that .............

3 Answers   Satyam,

what is qtp automation frame work,what is the use of that frame work?

64 Answers   Cap Gemini, IBM, iGate, TCS,

The xls contain data. how to get number of columns form the sheet?

4 Answers   Virtusa,

Explain how Selenium is different from UFT?

0 Answers  

How to execute a winrunner script in quicktest professional (qtp)?

0 Answers  

How to find the OS name by using QTP script?

2 Answers   IBM, Tech Mahindra,

I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.

0 Answers   Adea Solutions,