T-SQL System Functions

This section provides a comprehensive reference for system functions available in Transact-SQL (T-SQL) for SQL Server. These functions perform specific tasks, such as returning information about the current database, user, or server, or manipulating data in various ways.

Aggregate Functions

Aggregate functions perform a calculation on a set of values and return a single scalar value.

Date and Time Functions

These functions return or manipulate date and time values.

String Functions

String functions are used to manipulate character strings.

Mathematical Functions

Mathematical functions perform arithmetic operations.

System Information Functions

These functions return information about the SQL Server environment.

Other System Functions

Miscellaneous system functions with various purposes.