Ø User Defined Function can be executed using the “SELECT” clause whereas Stored Procedure cannot be Executed.

Ø User Defined Function does not return any output parameters while Stored Procedure will return output parameters.

Ø User Defined Function cannot make permanent changes to server environments while SP's can change some of the server environment.

Ø If there is an error in UDF its stops executing. But in SP's it just ignores the error and moves to the next statement.