NOT (Transact-SQL)

Negates a Boolean input.

Transact-SQL Syntax Conventions

Składnia

[ NOT ] boolean_expression

Arguments

• boolean_expression
  Is any valid Boolean expression.

Result Types

Boolean

Result Value

NOT reverses the value of any Boolean expression.

Uwagi

Using NOT negates an expression.

The following table shows the results of comparing TRUE and FALSE values using the NOT operator.

	NOT
TRUE	FALSE
FALSE	TRUE
UNKNOWN	UNKNOWN

Examples

The following example finds all Silver colored bicycles that do not have a standard price over $400.

USE AdventureWorks2012;
GO
SELECT ProductID, Name, Color, StandardCost
FROM Production.Product
WHERE ProductNumber LIKE 'BK-%' AND Color = 'Silver' AND NOT StandardCost > 400;
GO

Here is the result set.

ProductID Name Color StandardCost

--------- ------------------- ------ ------------

984 Mountain-500 Silver, 40 Silver 308.2179

985 Mountain-500 Silver, 42 Silver 308.2179

986 Mountain-500 Silver, 44 Silver 308.2179

987 Mountain-500 Silver, 48 Silver 308.2179

988 Mountain-500 Silver, 52 Silver 308.2179

(6 row(s) affected)

Zobacz także

Odwołanie

Expressions (Transact-SQL)

Built-in Functions (Transact-SQL)

Operators (Transact-SQL)

SELECT (Transact-SQL)

WHERE (Transact-SQL)