Print this chapterPrint this chapter

Data Manipulation Language

Built-in Functions

There are many built-in functions in SQL Server such as:

  1. Aggregate: returns summary values
  2. Conversion: transforms one data type to another
  3. Date: displays information about dates and times
  4. Mathematical: performs operations on numeric data
  5. String: performs operations on character strings, binary data or expressions
  6. System: returns a special piece of information from the database
  7. Text and image: performs operations on text and image data

Below you will find detailed descriptions and examples for the first four functions.