Stored Procedure and Function

Question

Hi, Ques What is the differences between Stored Procedure and Function ?

Senthilkumar · Answer

Hi, I have written very good article with 14 differences between the stored procedures and functions. http://www.c-sharpcorner.com/uploadfile/skumaar_mca/differences-between-procedures-and-functions/ I f you have any doubt then let me know.

Jignesh Trivedi · Answer

hi, 1) function can be used with Select statement however SP have to use EXEC or EXECUTE. 2) function hav't any out put parameter , SP have. 3) function is not able to change server configuration, SP can. 4) function can not used with XML FOR Clause, SP can. 5) function can use with join UDF, SP cannot. 6) function cannot have transaction within, we can use transaction with in SP. 7) fuction able to return Table variables but SP won't return Table Variables hope this help.

Vulpes · Answer

The same question has just been asked in this thread: http://www.c-sharpcorner.com/Forums/Thread/164513/difference-between-stored-procedure-and-function.aspx

Stored Procedure and Function

Answers (3)