SQL SERVER - Aggregate Functions, Date and Time Functions, String Functions, Conversion Functions

SQL Fundamentals

Data Retrieval

Select

Select Statement

Alias

Sorting

Operators

Arithmetic Operators

Comparison Operators

Logical Operators

Operator Precedence

Join

Grouping Datasets

ROLLUP and CUBE

Built-In Functions

Aggregate Functions

Conversion Functions

String Functions

Data Modification:

Insert

Select Into

Update

Delete and Truncate

Merge

Transactions

CTE

SQL Server has many built-in functions for performing various operations on set of data.

Following are the most common categories of built-in functions in SQL Server:

Aggregate Functions
Date and Time Functions
Conversion Functions
String Functions