Fuction returns a value whereas procedure doesnt return any
if some function calling is dere den function switch over 2
d function definition part directly but procedure go from
top 2 down linearly
Bot 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.
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.
hi Sudhananda reddy, in my resume, i written as , I Am
working as a Test Engineer for xyz company. IS IT RIGHT OR
WRONG? WHAT IS THE ACTUAL meaning of "IN XYZ COMPANY", "FOR
XYZ COMPANY", "WITH XYZ COMPANY".
This is Harish.1. What is object repositery .2. what is
frame works in QTP,what is keyword driven frame
work,explain it and how to associate the folders.3.the
build is developed in java, can we write scripting in
vb .4.what is discriptive progaram,how to write it.5.what
is process of QTp testing.6. how to associate the shared
repository. 7.what is implicit and explicit 8.what is
runtime data please replay me
I m using QTP 9.2 version., plz send me licence key is it
seat or concurrent licence key... plzzzzzzzzz plz help me
for this one and its Locking code:8-5C740 Maintenance
i am mallishwari,
i am veryn ew to testing but i have very much interest in
plse give me some guidence to get the job in testing.
send me required documents and faqs to
my personal id:
thans for advance.