SQL SERVER -- Built In Functions-- Part-16

                             
              Following are the Types of Built In Functions available in SQL SERVER. This is also called as System Defined Functions.
1.Date Functions

      GETDATE()
      YEAR()
      MONTH()
      DAY()
      WEEK()
      DATEPART()
      DATENAME()
      DATEDIFF()

2. Aggregate Functions

     SUM()

     MIN()

     MAX()

     COUNT()

     AVG()

3. Mathematical Functions

ABS()

CEILING()

FLOOR()

ROUND()

SQRT()

     SQUARE()
4. String Functions

SUBSTRING()

CHARINDEX()

REPLACE()

ISNULL()

STUFF()

LTRIM()

RTRIM()

COALESCE()

REVERSE()

RIGHT()

LEFT()

LOWER()

UPPER()

SPACE()

PATINDEX()

5. Conversion Functions

     CONVERT()

     CAST()

6. Ranking(Analytical) Functions

     ROW_NUMBER()

     RANK()

     DENSE_RANK()