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.