【SqlServer系列】表达式(expression)

1 概述

本篇这文章主要概述SqlServer表达式。

2 具体内容

2.1 使用范围

SQL Server（2008开始）；Azure SQL数据库；Azure SQL数据仓库；并行数据仓库

2.2 语法

是SQL Server数据库引擎评估以获取单个数据值的符号和运算符的组合。简单表达式可以是单个常量，变量，列或标量函数。运算符可用于将两个或多个简单表达式连接到一个复杂的表达式中。

1 -- Syntax for SQL Server and Azure SQL Database  
2 
3 { constant | scalar_function | [ table_name. ] column | variable   
4     | ( expression ) | ( scalar_subquery )   
5     | { unary_operator } expression   
6     | expression { binary_operator } expression   
7     | ranking_windowed_function | aggregate_windowed_function  
8 }

 1 -- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse  
 2 
 3 -- Expression in a SELECT statement  
 4 <expression> ::=   
 5 {  
 6     constant   
 7     | scalar_function   
 8     | column  
 9     | variable  
10     | ( expression  )  
11     | { unary_operator } expression   
12     | expression { binary_operator } expression   
13 }  
14 [ COLLATE Windows_collation_name ]  
15 
16 -- Scalar Expression in a DECLARE, SET, IF…ELSE, or WHILE statement  
17 <scalar_expression> ::=  
18 {  
19     constant   
20     | scalar_function   
21     | variable  
22     | ( expression  )  
23     | (scalar_subquery )  
24     | { unary_operator } expression   
25     | expression { binary_operator } expression   
26 }  
27 [ COLLATE { Windows_collation_name ]