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. Relational operators are used as table source in a DML statement.

SQL Server implements the following relational operators:


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

See also

What are the SQL database functions?