Parameter Markers

In accordance with the SQL-92 specification, an application cannot place parameter markers in the following locations. For a more comprehensive list, see the SQL-92 specification.

  • In a SELECT list

  • As both expressions in a comparison-predicate

  • As both operands of a binary operator

  • As both the first and second operands of a BETWEEN operation

  • As both the first and third operands of a BETWEEN operation

  • As both the expression and the first value of an IN operation

  • As the operand of a unary + or – operation

  • As the argument of a set-function-reference

For more information about parameter markers, see the SQL-92 specification. For more information about parameters, see Statement Parameters.

Show:
© 2014 Microsoft