Export (0) Print
Expand All

| (Bitwise Inclusive OR) (SSIS Expressions)

Performs a bitwise OR operation of two integer values. It compares each bit of its first operand to the corresponding bit of its second operand. If either bit is 1, the corresponding result bit is set to 1. Otherwise, the corresponding result bit is set to zero (0).

Both conditions must be a signed integer data type or both conditions must be an unsigned integer data type.

integer_expression1 | integer_expression2

integer_expression1 ,integer_ expression2

Is any valid expression of a signed or unsigned integer data type. For more information, see Integration Services Data Types.

Determined by data types of the two arguments. For more information, see Implicit Data Type Conversion in Expressions.

If either condition is null, the expression result is null.

This example performs a bitwise inclusive OR operation between the variables NumberA and NumberB. NumberA contains 3 (00000011) and NumberB contains 9 (00001001).

@NumberA | @NumberB

The expression evaluates to 11 (00001011).

00000011

00001001

-----------

00001011

This example performs a bitwise inclusive OR operation between the ReorderPoint and SafetyStockLevel columns.

ReorderPoint | SafetyStockLevel

If ReorderPoint is 10 and SafetyStockLevel is 8, the expression evaluates to 10 (00001010).

00001010

00001000

-----------

00001010

This example performs a bitwise inclusive OR operation between two integers.

3 | 5 

The expression evaluates to 7 (00000111).

00000011

00000101

-----------

00000111

Community Additions

ADD
Show:
© 2014 Microsoft