述語Predicates

適用対象: ○SQL Server XAzure SQL Database XAzure SQL Data Warehouse XParallel Data WarehouseAPPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

TRUE、FALSE または、UNKNOWN を評価する式です。Is an expression that evaluates to TRUE, FALSE, or UNKNOWN. 述語は WHERE 句と HAVING 句の検索条件、FROM 句の結合条件、および、ブール値が必要なその他の構成要素で使用されます。Predicates are used in the search condition of WHERE clauses and HAVING clauses, the join conditions of FROM clauses, and other constructs where a Boolean value is required.

このセクションの内容In This Section

SQL ServerSQL Server では、以下の述語が用意されています。provides the following predicates.

CONTAINSCONTAINS
FREETEXTFREETEXT
IS [NOT] NULLIS [NOT] NULL

参照See Also

BETWEEN (Transact-SQL) BETWEEN (Transact-SQL)
EXISTS (Transact-SQL) EXISTS (Transact-SQL)
IN (Transact-SQL) IN (Transact-SQL)
LIKE (Transact-SQL) LIKE (Transact-SQL)
検索条件 (Transact-SQL)Search Condition (Transact-SQL)