Predicates
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
A predicate is an expression that evaluates to TRUE
, FALSE
, or UNKNOWN
. 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.
For more information, including how to specify a search condition, see Search condition.
SQL Server provides the following predicates:
- CONTAINS (Transact-SQL)
- FREETEXT (Transact-SQL)
- IS [NOT] DISTINCT FROM (Transact-SQL)
- IS NULL (Transact-SQL)
Related content
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre