详解SqlServer 表达式(expression)

-- Syntax for SQL Server and Azure SQL Database 
{ constant | scalar_function | [ table_name. ] column | variable 
 | ( expression ) | ( scalar_subquery ) 
 | { unary_operator } expression 
 | expression { binary_operator } expression 
 | ranking_windowed_function | aggregate_windowed_function 
}
-- Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse 
-- Expression in a SELECT statement 
<expression> ::= 
{ 
 constant 
 | scalar_function 
 | column 
 | variable 
 | ( expression ) 
 | { unary_operator } expression 
 | expression { binary_operator } expression 
} 
[ COLLATE Windows_collation_name ] 
-- Scalar Expression in a DECLARE, SET, IF…ELSE, or WHILE statement 
<scalar_expression> ::= 
{ 
 constant 
 | scalar_function 
 | variable 
 | ( expression ) 
 | (scalar_subquery ) 
 | { unary_operator } expression 
 | expression { binary_operator } expression 
} 
[ COLLATE { Windows_collation_name ]