This topic has not yet been rated - Rate this topic

() (Parentheses) (SSIS Expressions)

SQL Server 2008

SQL Server 2008 R2
SQL Server 2005
SQL Server 2012

Identifies the evaluation order of expressions. Expressions enclosed in parentheses have the highest evaluation precedence. Nested expressions enclosed in parentheses are evaluated in inner-to-outer order.

Parentheses are also used to make complex expressions easier to understand.

Syntax

(expression)

Arguments

expression: Is any valid expression.

Result Types

The data type of expression. For more information, see Integration Services Data Types.

Examples

This example shows how the use of parenthesis modifies the precedence of operators. The first expression evaluates to 100, whereas the second one evaluates to 31.

(5 + 5) * (4 + 6)
5 + 5 * 4 + 6

Concepts

Operator Precedence and Associativity

Other Resources

Operators (SSIS Expressions)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD