stored procedure and function [Resolved]

Posted by Jiturcm under Sql Server on 4/19/2011 | Points: 10 | Views : 1919 | Status : [Member] | Replies : 4
difference between stored procedure and function

jitendra kumar mahapatro


Responses

Posted by: Siva.boggarapu on: 4/19/2011 [Member] Starter | Points: 50

Up
0
Down

Resolved
Functions can be called inside select stmt but not the procedures

A function always return a values while procedure can return one or more values through Parameters.

A function can call directly by sql statement like select func_name from dual while procedure cannot.

procedure can call in another project but function work in same project .


you can use DDL stmt inside function.





Regards,
siva,
skyme:siva.boggarapu.ef

Jiturcm, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Akiii on: 4/19/2011 [Member] Bronze | Points: 25

Up
0
Down
@jitendra...

Hi,
Try searching dotnetfunda because this question has already been answered. Anyway, please refer to the links below, the first link is from dotnetfunda only.....

http://www.dotnetfunda.com/interview/exam4096-what-is-the-difference-between-stored-procedure-and-function-.aspx

http://www.mindstick.com/Blog/57/Difference%20between%20Function%20and%20Stored%20Procedure

http://www.dotnetspider.com/forum/21568-difference-between-stored-procedure-function.aspx

http://www.dotnetspider.com/resources/18920-Difference-between-Stored-Procedure-Functions.aspx

I hope this will make your concepts clear.

Thank and Regards
Akiii

Jiturcm, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Mesh_2010 on: 4/27/2011 [Member] Starter | Points: 25

Up
0
Down

Hi,

Difference between Store Procedure and function

1. Procedure can return zero or n values whereas function can return one value which is mandatory.

2. Procedures can have input, output parameters for it whereas functions can have only input parameters.

3. Procedure allow select as well as Data Manipulation Language statement in it whereas function allow only select statement in it.

4. Functions can be called from procedure whereas procedures cannot be called from function.

5. Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.

Thanks
RameSH sinGH

Jiturcm, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Dilip0165 on: 2/1/2012 [Member] Starter | Points: 25

Up
0
Down
Hi to find the straight difference between SP and UFD
just visit

http://sqldebate.blogspot.in/2012/02/diffrence-between-stored-procedure-and.html

Jiturcm, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response