Post reply

StoredProc vs Function

  • September 7, 2019 at 2:06 pm

    #3678195

    when we compare the sql server SP vs Functions

    SP may or may not return the value. where as functions must return a value.

    can any one give a example where SP not giving the return value as well as returning the value.

     

    Thank you

    Shiva

  • September 7, 2019 at 4:08 pm

    #3678203

    Stored Procedures always give a return value.  What stored procedures do not always have is output parameters, which are different than function return values.

    The return value from a SP is intended to be used differently than a return value from a function, just like how functions are intended to be used different than SP's.

  • September 8, 2019 at 10:12 pm

    #3678357

    Thank you Boss.Now I am clear

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply