SQL Server Relational Operators¶
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:
| Function | Description | Syntax |
|---|---|---|
| GENERATE_SERIES | Generates a series of numbers within a given interval wherein the interval and the step between series values are defined by the user. | GENERATE_SERIES ( start , stop [ , step ] ) |
| OPENDATASOURCE | ||
| OPENQUERY | ||
| OPENROWSET | ||
| OPENXML | ||
| OPENJSON | ||
| PREDICT | ||
| STRING_SPLIT | Table-valued function that splits a string into rows of substrings, based on a specified separator character | STRING_SPLIT ( string, separator [ , enable_ordinal ] ) |