What is the difference between "procedure" and "function?

1 view

Skip to first unread message

ragav...@gmail.com

unread,

Aug 28, 2006, 4:31:46 AM8/28/06

to SQL Developers

________________________________________

What is the difference between "procedure" and
"function?________________________________________

The difference mejor between procedure and function is that function
must return value. that should be only single and function can pass any
no. parameter but come out only one value only using return statement.
procedure can pass any parameter and came out any no. of values there
no any RETURN word.

________________________________________

What is the difference between "procedure" and "function?
________________________________________
The major difference between procedure and function is that procedure
is to be compile only one time and vice versa.Execution of procedure is
faster then function

________________________________________

What is the difference between "procedure" and "fu...
________________________________________

1.The major difference between procedure and function is that
procedure is to be compile only one time and vice versa.Execution of
procedure is faster then function
2.Function can be used in select Queries statement,but in
stored procedure it's not possible.
3.Fuction can return a single value only.Stored procedure return
more than one value.

________________________________________

What is the difference between "procedure" and "fu...
________________________________________

The major difference between procedure and function is that 1.
Procedure can be compiled only once and vice versa. 2. Execution of
procedure is faster then function 3. Function can be used in select
Queries statement in stored procedure. But it's not possible using
straight away. 4. Function can return a single value only.

________________________________________

What is the difference between "procedure" and "fu...
________________________________________

SP Accepts both i/p and o/p paramateres where function accespts only
i/p paramateres, fuction can be used in select stmt as well as function
can be used as user defined datatype