Relational operators (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics 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?