! (Logical Not) (SSIS Expression)
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
Negates a Boolean operand.
Note
The ! operator cannot be used in conjunction with other operators. For example, you cannot combine the ! and the > operators into the !>. operator.
Syntax
!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
Remarks
The following table shows the result of the ! operation.
Original Boolean expression | After applying the ! operator |
---|---|
TRUE | FALSE |
NULL | NULL |
FALSE | TRUE |
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())
See Also
Operator Precedence and Associativity
Operators (SSIS Expression)
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin