Answer / scorpio.mishra

1->stored procedure can not be written as a column name but
function can be written as a column name
2->result set of stored procedure can not be used in
joining tables but table return by function can be used in
joins

Answer / darshan shah

SP may return value or may not ,function always treturn
value.
SP cannot use in sselect statment or in sql stattment ,We
can use Function in any where in sql statment.
Packeage is set of statment,SP,Function Which run one by
one statment in that.

Answer / pratap557

In general SPs are sequential block of PL/SQL for
Transaction
Func are used for specific calculation / selection

Answer / bunty_18

1>Stored procedure is pre-executed block of code whereas
function is not.
2>Stored procedure may return zero,one or more than one value
whereas function always return one and only one value..
3>We can use try catch block in stored procedure whereas
function doesn't support try catch block...
4>We can't use stored procedure in select statement whereas we
use function in select statement..

Answer / pratap557

We cannot write DML in Function whereas in SPs we can

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

Explain about nested stored procedure?

0 Answers  

What stored by the master? : sql server database administration

0 Answers  

How to encrypt data between dialogs?

0 Answers  

How to recreate an existing index in ms sql server?

0 Answers  

What do you mean by an execution plan? How would you view it?

0 Answers  

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

What is the use of SCOPE_IDENTITY() function?

2 Answers  

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

what are different types of raid configurations? : Sql server database administration

0 Answers  

What is the process of normalization?

0 Answers  

What are different types of join?

0 Answers