what are difference between function and the stored procedure in 2008 version

Posted by Jameschowdare under Sql Server on 2/4/2010 | Views : 1512 | Status : [Member] | Replies : 6
what are difference between function and the stored procedure in 2008 version




Responses

Posted by: Raja on: 2/4/2010 [Member] Starter

Up
0
Down
This may help you http://www.c-sharpcorner.com/UploadFile/skumaar_mca/Diff-Proc-Func08062009071904AM/Diff-Proc-Func.aspx

Regards,
Raja, USA

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

Posted by: Bubbly on: 2/4/2010 [Member] Bronze

Up
0
Down
Hello,

Check this link

http://www.dotnetspider.com/resources/19189-Differences-between-User-Defined-Function-Stored-Procedures-SQL-Server.aspx

++
Thanks & Regards,
Deepika

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

Posted by: Vuyiswamb on: 2/4/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Please look at this

http://www.go4expert.com/forums/showthread.php?t=329

Thank you for Posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

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

Posted by: Nallurikalyani on: 2/10/2010 [Member] Starter

Up
0
Down
The main Difference Between Procedure & function is;
1)Function should return a value But procedure may or maynot return value.

2)Function doesn't accept parameter where as procedure accept parameter.

Jameschowdare, 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 I have Describe the straight difference between SP and UDF
hust visit the

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

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

Posted by: Sksamantaray on: 2/1/2012 [Member] Silver | Points: 25

Up
0
Down
All the above links are helpful.
The link provided by Deepika has lot of differences.
Thanks,
Sanjay

Thanks,
Sanjay

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

Login to post response