Specify a scalar value.

 

Syntax

 

<value expression> ::=

 

<common value expression> ::=

 

<value expression primary> ::=

 

<nonparenthesized value expression primary> ::=

 

<value specification> ::=

 

<unsigned value specification> ::=

 

<general value specification> ::=

 

|

|

|

|

|

|

|

|

 

SQL-parameter-reference

SQL-variable-reference

<dynamic parameter specification>

USER

CURRENT_USER

SESSION_USER

SYSTEM_ROW#

NEWGUID

ROWSREAD

ROWSAFFECTED

 

<target specification> ::=

 

|

|

|

 

SQL-parameter-reference

SQL-variable-reference

column-reference

<dynamic parameter specification>

 

 

Usage

 

Value expressions return values with a data type declared by the expression, and can be used in SQL everywhere a value is expected and the particular data type is permitted. Value expressions can be as simple as a literal or a column reference, or complex expressions involving arithmetic operations, combined boolean logic, scalar subqueries, case expressions and SQL functions.

 

 


 

Conformance

 

SQL:2003 standard

-

-

-

-

Core SQL

Feature F052 "Intervals and datetime arithmetic"

Feature T031 "BOOLEAN data type"

Feature F471 "Scalar subquery values"

 


 

Numeric Value Expressions

String Value Expressions

DateTime Value Expressions

Boolean Value Expressions

Row Value Expressions

Subqueries

Case Expressions

Cast Specification