Skip to content

Latest commit

 

History

History
34 lines (25 loc) · 1.19 KB

parameter-markers.md

File metadata and controls

34 lines (25 loc) · 1.19 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Parameter Markers
Parameter Markers
David-Engel
v-davidengel
01/19/2017
sql
connectivity
reference
minimum SQL syntax supported [ODBC]
ODBC drivers [ODBC], minimum SQL syntax supported
parameter markers [ODBC]

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.