|| (Logical OR) (SSIS Expression)

Performs a logical OR operation. The expression evaluates to TRUE if one or both conditions are TRUE.

Składnia

boolean_expression1 || boolean_expression2

Arguments

• boolean_expression1, boolean_expression2
  Is any valid expression that evaluates to TRUE, FALSE, or NULL.

Result Types

DT_BOOL

Uwagi

The following table shows the result of the || operator.

SSIS Expression Examples

This example uses the StandardCost and ListPrice columns. The example evaluates to TRUE if the value of the StandardCost column is less than 300 or the ListPrice column is greater than 500.

StandardCost < 300 || ListPrice > 500

This example uses the variables SPrice and LPrice instead of numeric literals.

StandardCost < @SPrice || ListPrice > @LPrice

Zobacz także

Odwołanie

| (Bitwise Inclusive OR) (SSIS Expression)

^ (Bitwise Exclusive OR) (SSIS Expression)

Koncepcje

Operator Precedence and Associativity

Inne zasoby

Operators (SSIS Expression)