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
Atsiliepimai
https://aka.ms/ContentUserFeedback.
Jau greitai: 2024 m. palaipsniui atsisakysime „GitHub“ problemų, kaip turiniui taikomo atsiliepimų mechanizmo, ir pakeisime jį nauja atsiliepimų sistema. Daugiau informacijos žr.Pateikti ir peržiūrėti atsiliepimą, skirtą