Stored Procedure - Comparison With Functions

Comparison With Functions

  • A function is a subprogram written to perform certain computations
  • A scalar function returns only a single value (or NULL), whereas a table function returns a (relational) table comprising zero or more rows, each row with one or more columns.
  • Functions must return a value (using the RETURN keyword), but for stored procedures this is not compulsory.
  • Stored procedures can use RETURN keyword but without any value being passed.
  • Functions could be used in SELECT statements, provided they don’t do any data manipulation. However, procedures cannot be included in SELECT statements.
  • A stored procedure can return multiple values using the OUT parameter or return no value at all..

Read more about this topic:  Stored Procedure

Famous quotes containing the words comparison with, comparison and/or functions:

    “He was a superior man. He did not value his bodily life in comparison with ideal things. He did not recognize unjust human laws, but resisted them as he was bid. For once we are lifted out of the trivialness and dust of politics into the region of truth and manhood.”
    —Henry David Thoreau (1817–1862)

    “In everyone’s youthful dreams, philosophy is still vaguely but inseparably, and with singular truth, associated with the East, nor do after years discover its local habitation in the Western world. In comparison with the philosophers of the East, we may say that modern Europe has yet given birth to none.”
    —Henry David Thoreau (1817–1862)

    “The mind is a finer body, and resumes its functions of feeding, digesting, absorbing, excluding, and generating, in a new and ethereal element. Here, in the brain, is all the process of alimentation repeated, in the acquiring, comparing, digesting, and assimilating of experience. Here again is the mystery of generation repeated.”
    —Ralph Waldo Emerson (1803–1882)