Diffrence between Stored Procedure and User Define Function in SQL

These are the main difference between Stored Procedure and User Define Function


Functions 


-can be used with Select statement
-Not returning output parameter but returns Table variables
-You can join UDF
-Can not be used to change server configuration
-Can not be used with XML FOR clause
-Can not have transaction within function


Stored Procedure

-have to use EXEC or EXECUTE

-return output parameter

-can create table but won’t return Table Variables

-you can not join SP

-can be used to change server configuration

-can be used with XML FOR Clause

-can have transaction within SP