Answer / roopesh kumar

(1) Procedure may or may not return value but function
should.

(2) We can't call a procedure inside a sql stmt but
function can.

Answer / guest

Hi,

Basic Difference is Function must return a value and
Procedure can or cannot return a value using out parameter.



Thanks!

Answer / manojbatra071

a procedure can return none,one or more than one value but a
function can return one and only one value everytime

Answer / shasi

Hi,

The main think is function canbe used in sql select
statement but procedure wer can't use.procedure redurn more
then value(max:1024)funcion must return 1 value

Answer / sandeep sahoo

Prcocedure Will do Action whereas Function Will do Calculation

Answer / devi

1.procedure does not return any value whree as functions
return values
2.a procedure can be called independently where as a
function is called inside a procedure

What is the difference between sum and count in sql?

0 Answers  

please explain database architecture..

1 Answers   Infosys,

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

State the advatage and disadvantage of Cursor's?

2 Answers  

Define tables and fields in a database

0 Answers  

Is primary key always clustered index?

0 Answers  

What is TABLE SPACE?

4 Answers   ABB, TCS,

what are the difference between clustered and a non-clustered index? : Sql dba

0 Answers  

How can I change database name in sql?

0 Answers  

What is memory optimized?

0 Answers