FUNCTIONS   :-

Built in functions in sql server categorized into two categories:

  • Single row Functions
  • Multi row Functions

(I) Single Row Functions in SQL:

These function are capable of processing are row at a time and returns one value per row.

Single row function are catagorized into following categories  :

  1. STRING
  2. DATE
  3. MATHEMATICAL
  4. CONVERSION
  5. SPECIAL
  6. OLAP