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