| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | helpviewer_keywords | dev_langs | monikerRange | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Relational operators (Transact-SQL) |
A relational operator is a syntax element that can accept one or more named or unnamed input parameters and returns a result set. |
rwestMSFT |
randolphwest |
04/26/2024 |
sql |
t-sql |
reference |
|
|
|
>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric |
[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]
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:
- GENERATE_SERIES (Transact-SQL)
- 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.