! (Logical Not) (SSIS Expression)

Negates a Boolean operand.

[!UWAGA]

The ! operator cannot be used in conjunction with other operators. For example, you cannot combine the ! and the > operators into the !>. operator.

Składnia

!boolean_expression
        

Arguments

• boolean_expression
  Is any valid expression that evaluates to a Boolean. For more information, see Integration Services Data Types.

Result Types

DT_BOOL

Uwagi

The following table shows the result of the ! operation.

Expression Examples

This example evaluates to FALSE if the Color column value is "red".

!(Color == "red")

This example evaluates to TRUE if the value of the MonthNumber variable is the same as the integer that represents the current month. For more information, see MONTH (SSIS Expression) and GETDATE (SSIS Expression).

!(@MonthNumber != MONTH(GETDATE())

Zobacz także

Koncepcje

Operator Precedence and Associativity

Inne zasoby

Operators (SSIS Expression)