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 :