Relational operators

Analytics Platform System (PDW)

SQL analytics endpoint in

Microsoft Fabric

Warehouse 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.

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.

What are the SQL database functions?