2/20/2007

Difference between Stored Procedure and Function (UDF)

5:35 PM  , , , , , , , ,  7 comments

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

7 comments:

  1. AnonymousApril 27, 2007 at 8:46 PM

    Thank you. This was very helpful.

    ReplyDelete
  2. Vibushan L NarayanDecember 18, 2008 at 12:13 AM

    Thanks a lot! A very helpful information.

    ReplyDelete
  3. AnonymousFebruary 11, 2010 at 11:25 AM

    good one...

    ReplyDelete
  4. AnonymousJune 17, 2010 at 10:28 AM

    its seems to be very simple

    ReplyDelete
  5. SweetGuyMay 2, 2011 at 11:14 AM

    Thanxs A Lot for Giving your valuable time...

    ReplyDelete
  6. sivasrinivashMay 19, 2012 at 10:49 AM

    good job!!!

    ReplyDelete
  7. LalitMay 15, 2013 at 4:21 PM

    20 main differences between Stored procedures and Functions in Sql Server
    http://www.webcodeexpert.com/2013/04/difference-between-stored-procedures.html

    ReplyDelete

I appreciate your time, thanks for posting your comment. I will review and reply to your comment as soon as I can.

Thank you
Hemantgiri