Differences Between User Defined Functions and Stored Procedures in SQL Server

Hi Arun,


Please refer the below links

http://www.c-sharpcorner.com/uploadfile/skumaar_mca/differences-between-procedures-and-functions/

http://databases.about.com/od/sqlserver/a/procs_vs_functs.htm

Thanks

Check out this article:

http://www.codeproject.com/Tips/286539/Difference-between-stored-procedure-and-function