Parameter Types
The following table lists the available parameter types and their valid operands and values. The SingleValue parameter type can appear anywhere in a query. The SelectOrder parameter type is used in the Select clause of the query. The remaining parameter types appear in the Where clause of the query.
Paramtype | Operand1 | Value1 | Operand2 | Value2 |
---|---|---|---|---|
ParamType_DateRange | DateRangeOpnd_All
DateRangeOpnd_From DateRangeOpnd_OnOrBefore DateRangeOpnd_Today DateRangeOpnd_ThisWeek DateRangeOpnd_ThisMonth DateRangeOpnd_ThisQuarter DateRangeOpnd_ThisYear DateRangeOpnd_Yesterday DateRangeOpnd_LastWeek DateRangeOpnd_LastMonth DateRangeOpnd_LastQuarter DateRangeOpnd_LastYear |
Required for the DateRangeOpnd_From or DateRangeOpnd_OnOrBefore operand.
For the DateRangeOpnd_From operand, the beginning date of a range to return. For the DateRangeOpnd_OnOrBefore operand, the last date to include. Not applicable for the other operand types. Date format = MM/DD/YYYY |
Not applicable. | Required for the DateRangeOpnd_From operand.
The end date of a range to return. Not applicable for the other operand types. |
ParamType_Expression | ExpOpnd_All
ExpOpnd_Equals ExpOpnd_NotEquals ExpOpnd_IsNull ExpOpnd_IsNotNull ExpOpnd_LessThan (only used for numeric types) ExpOpnd_LessThanOrEquals (only used for numeric types) ExpOpnd_GreaterThan (only used for numeric types) ExpOpnd_GreaterThanOrEquals (only used for numeric types) ExpOpnd_Like (only used for String types) ExpOpnd_NotLike (only used for String types) |
Not applicable for the ExpOpnd_None operand.
Required for the other parameter types. Valid types are:
|
Same operand types as Operand1.
Not applicable for the ExpOpnd_None operand. Optional for the other operand types. |
Required if Operand2 is specified. |
ParamType_SelectOrder | SelectOrderOpnd_All (SQL only)
SelectOrderOpnd_Distinct (SQL only) SelectOrderOpnd_Top SelectOrderOpnd_Bottom (MDX only) |
Required for the SelectOrderOpnd_Top or SelectOrderOpnd_Bottom operand.
An Integer specifying the number of rows to return. Not applicable for the SelectOrderOpnd_All operand. |
Not applicable. | Not applicable. |
ParamType_SingleValue | Not applicable | Required String value.
The value for this operand is a text field that can accommodate any type of entry. Two examples are: booleanVal = "True" and Time = "12:59:59". |
Not applicable. | Not applicable. |
ParamType_SiteName (SQL query only) |
SiteNameOpnd_All
SiteNameOpnd_Equals SiteNameOpnd_NotEquals SiteNameOpnd_Like SiteNameOpnd_NotLike |
Not applicable for the SiteNameOpnd_All operand.
Required String value for the others. |
Not applicable. | Not applicable. |
Copyright © 2005 Microsoft Corporation.
All rights reserved.