Blog

Difference between Stored Procedure (SP) and User Defined Function

Posted by Venkatesan Jayakantham Blogs | SQL 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 
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.
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.