Ø 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.
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
For free Ebook : http://kaashivinfotech.com/Ebooks.aspx