USING Clause
Syntax Element … |
Specifies … |
USING |
Keyword to introduce the clause. |
name (value) |
One or more name-value pairs. |
name (scalar_subquery) |
You can also specify a subquery that returns a single row. Only one subquery is allowed for each name. The subquery must return only one row and the WHERE clause of the subquery must reference a unique primary index or unique secondary index. The row can have multiple values (columns) but all values must be the same data type. |