Relational operators (Transact-SQL)

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 SQL database in Microsoft Fabric

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

Use a relational operator like a table-valued function in a query or T-SQL statement.

Related content

• What are the SQL database functions?