The query parameters (see Query Parameters) are evaluated when the query is parsed. For repeat queries, this occurs when the query is defined, which means the values will be fixed at execution time, regardless of the values sent when executed.

Repeat query parameters that take on unique values at execution time are possible using an extension to the query parameter mechanism described in Query Parameters. These extended parameter markers take the form:

where n is replaced by sequentially increasing integers starting with 0.