| description | Relational operators (Transact-SQL) | ||
|---|---|---|---|
| title | Relational operators (Transact-SQL) | Microsoft Docs | ||
| ms.custom | |||
| ms.date | 05/25/2021 | ||
| ms.prod | sql | ||
| ms.prod_service | sql-database | ||
| ms.reviewer | |||
| ms.technology | t-sql | ||
| ms.topic | reference | ||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| author | LitKnd | ||
| ms.author | kendralittle |
A relational operator is a syntax element that can accept one or more named or unnamed input parameters and returns a result set. Relational operators are used as table source in a DML statement.
SQL Server implements the following relational operators:
- OPENDATASOURCE (Transact-SQL)
- OPENQUERY (Transact-SQL)
- OPENROWSET (Transact-SQL)
- OPENXML (Transact-SQL)
- OPENJSON (Transact-SQL)
- PREDICT (Transact-SQL)
- STRING_SPLIT (Transact-SQL)
Use a relational operator like a table-valued function in a query or T-SQL statement.