| expression |
expression |
| + |
expression + expression |
| - |
expression - expression |
| / |
expression / expression |
| < |
expression < expression |
| <= |
expression <= expression |
| <> |
expression <> expression |
| = |
expression = expression |
| > |
expression > expression |
| >= |
expression >= expression |
| AND |
boolean_expression AND boolean_expression |
| AVG |
AVG (expression) |
| BETWEEN |
BETWEEN (test_expression, begin_expression, end_expression) |
| CASE WHEN…THEN…ELSE…END |
CASE WHEN (boolean_expression) THEN (result_expression) […n] [ELSE (else_result_expression)] END |
| CASE…WHEN…THEN…ELSE…END |
CASE (input_expression) WHEN (when_expression) THEN (result_expression) […n] [ELSE (else_result_expression)] END |
| CAST…AS |
CAST (expression AS data_type) |
| CONCAT |
CONCAT (expression, expression[,expression…]) |
| CONVERT |
CONVERT (data_type [( length)], expression[, style]) |
| COUNT |
COUNT (expression) |
| DATEADD |
DATEADD (datepart, number, expression) |
| DATEDIFF |
DATEDIFF (datepart, startdate, enddate) |
| DATEPART |
DATEPART (datepart, date) |
| DISTINCT |
DISTINCT (column) or DISTINCT column |
| GETDATE |
GETDATE () |
| IF…THEN…ELSE…END |
IF (boolean_expression) THEN (true_expression) [ELSE (false_expression)] END |
| IIF |
IIF (boolean_expression, true_expression, [false_expression]) |
| ISNULL |
ISNULL (check_expression, replacement_value) |
| LEN |
LEN (expression) |
| MAX |
MAX (expression) |
| MIN |
MIN (expression) |
| OR |
boolean_expression OR boolean_expression |
| ROUND |
ROUND (expression, length[, function]) |
| RUNNING AVG |
RUNNINGAVG (column) |
| RUNNING COUNT |
RUNNINGCOUNT (column) |
| RUNNING SUM |
RUNNINGSUM (column) |
| SUM |
SUM (expression) |