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:

    “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)

    “It is comparison than makes people miserable.”
    —Chinese proverb.

    “One of the most highly valued functions of used parents these days is to be the villains of their children’s lives, the people the child blames for any shortcomings or disappointments. But if your identity comes from your parents’ failings, then you remain forever a member of the child generation, stuck and unable to move on to an adulthood in which you identify yourself in terms of what you do, not what has been done to you.”
    —Frank Pittman (20th century)