T-SQL Function Overview in SQL Server
What Functions Are Available in SQL Server?
Microsoft SQL Server provides a rich set of built-in functions to help developers and administrators handle complex queries, data transformations, calculations, and data analysis. This article outlines the major categories of T-SQL functions, complete with helpful links to official documentation.
Analytic Functions
Analytic functions compute an aggregate value across a group of rows and return a value for each row. These are ideal for tasks such as running totals, moving averages, and ranking.
Aggregate Functions
These functions perform a calculation on a set of values and return a single value.
Configuration Scalar Functions
These functions return information about the current configuration of the SQL Server session.
Data Type Casting and Conversion Functions
Functions for converting and casting between SQL Server data types:
Security Functions
Symmetric Encryption & Decryption
Asymmetric Encryption & Decryption
Signature and Validation
Date and Time Data Types
SQL Server provides rich support for various date and time types. Each type has specific attributes including format, range, precision, and size.
- time: High-precision time values
