Built-in Functions (Transact-SQL)
This section describes the Transact-SQL (T-SQL) built-in functions available in Microsoft SQL Server. These functions perform calculations, manipulate data, and return information about the data. They are categorized by their functionality.
Aggregate Functions
Aggregate functions operate on a set of rows and return a single value.
Scalar Functions
Scalar functions operate on a single value and return a single value.
String Functions:
Date and Time Functions:
Mathematical Functions:
System Functions:
Ranking Functions
Ranking functions assign a rank to each row within a partition of a result set.
Window Functions
Window functions perform calculations across a set of table rows that are related to the current row.