SQL Server Functions

This section provides you with the commonly used SQL Server functions, including aggregate functions, date functions, string functions, system functions, and window functions.

SQL Server Aggregate Functions

This tutorial introduces you to the SQL Server aggregate functions and shows you how to use them to calculate aggregates.

SQL Server Date Functions

This page lists the most commonly used SQL Server Date functions that allow you to handle date and time date effectively.

SQL Server String Functions

This tutorial provides with many useful SQL Server String functions that allow you to manipulate character string effectively.

SQL Server System Functions

This page provides you with the commonly used system functions in SQL Server that return objects, values, and settings in SQL Server.

SQL Server Window Functions

SQL Server Window Functions calculate an aggregate value based on a group of rows and return multiple rows for each group.