Functions in SQL Server – SQL Server Tutorial

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