<< Click to Display Table of Contents >> Navigation:  SQL features > MS SQL functions

Aggregate functions

STRING_AGG

 

String functions
CHAR(NUMBER)
CHARINDEX(STRING, STRING, NUMBER)
CONCAT(STRING, STRING)
CONCAT_WS(STRING, STRING, STRING)
DATALENGTH: DATALENGTH(STRING)
FORMAT(STRING, STRING)
LEFT(STRING, NUMBER)
LEN(STRING)
LOWER(STRING)
LTRIM(EXP)
REPLACE(EXPR, SEARCH)
REVERSE(|)
RIGHT(STRING, NUMBER)
RTRIM(EXP)
SUBSTRING(VARCHAR, NUMBER, NUMBER): VARCHAR

STRING_SPLIT(Expression, Sep, Index)

 

Mathematical functions

ABS(NUMBER)
ACOS(NUMBER)
ASIN(NUMBER)
ATAN(NUMBER)
ATAN2(NUMBER)
CEIL(NUMBER)
COS(NUMBER)
COSH(NUMBER)
EXP(NUMBER)
FLOOR(NUMBER)
LN(NUMBER)
LOG(NUMBER, NUMBER)
POWER(NUMBER, NUMBER)
ROUND(NUMBER)
SIGN(NUMBER)
SIN(NUMBER)
SINH(NUMBER)
SQRT(NUMBER)
TAN(NUMBER)

TANH(NUMBER)

 

Date functions

DATEADD(NUMBER, DATE_PART, DATETIME): DATETIME
DATEDIFF(DATE_PART, DATETIME, DATETIME): NUMBER
DATEFROMPARTS(YEAR, MONTH, DAY): DATE
DATENAME(PART, DATE): NUMBER
DATEPART(PART, DATE): NUMBER
DAY(DATE)
MONTH(DATE): NUMBER
YEAR(DATE): NUMBER