Results 1 to 6 of 6

Thread: What are differences between function and stored procedure?

  1. #1
    Registered
    Join Date
    Mar 2016
    Posts
    76

    What are differences between function and stored procedure?

    What are differences between function and stored procedure?

  2. #2
    Registered
    Join Date
    May 2016
    Posts
    62
    Function returns only one value but procedure returns one or more than one value.

  3. #3
    Registered pxljobs's Avatar
    Join Date
    Jul 2016
    Location
    Bangalore
    Posts
    290
    Function it must return value,it will allow only selected elements,not allow us to try-catch block,transaction not allow within function,functions can be called from select statement,transaction not allowed within the function.
    Stored procedure not return any value someone return value for exception handling you can use try catch block procedure not use any select statement we can use call/execute
    the stored procedure.

  4. #4
    Basic Difference. Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values). Functions can have only input parameters for it whereas Procedures can have input/output parameters . Functions can be called from Procedure whereas Procedures cannot be called from Function.

  5. #5

  6. #6
    Registered
    Join Date
    Nov 2016
    Posts
    521
    Capacity must restore an esteem however in Stored Procedure it is discretionary( Procedure can return zero or n esteems). Capacities can have just info parameters for it though Procedures can have input/yield parameters . Capacities can be called from Procedure though Procedures can't be called from Function.

Similar Threads

  1. Search function
    By its1mc in forum HTML, CSS, Layout, and Design
    Replies: 4
    Last Post: 07-07-2011, 11:47 PM
  2. Tribal Fusion Channel CPM differences
    By Generalissimo in forum Advertising & Affiliate Programs
    Replies: 12
    Last Post: 04-27-2007, 11:12 AM
  3. Am I just gonna have to live with the differences?
    By deronsizemore in forum HTML, CSS, Layout, and Design
    Replies: 9
    Last Post: 07-30-2006, 04:47 PM
  4. Replies: 1
    Last Post: 03-01-2006, 02:41 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •