Difference between Stored Procedure (SP) and User Defined Function

By Venkatesan Jayakantham May 15, 2012
Difference between Stored Procedure (SP) and User Defined Function

Ø   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 
Venkatesan Jayakantham

I am Venkatesan Prabu Jayakantham(SQL Server DBA and Dotnet developer) from India (Tamil Nadu). A Microsoft SQL Server MVP,MCITP,MCTS,MCAD,CCNA,QAI certified Expert.  I am a Mindcracker MVP for the year 2010. &nbs... Read more

COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs