Specifies the SQL data type of a query parameter or PivotTable field.
Contained In
Remarks
This element contains one of the following string constants corresponding to the type of data returned by an SQL query:
| BigInteger | Binary |
| Bit | Character |
| Date | Decimal |
| Double | Float |
| GUID | Integer |
| LongVariableBinary | LongVariableCharacter |
| Numeric | Real |
| SignedBigInteger | SignedInteger |
| SignedSmallInteger | SignedTinyInteger |
| SmallInteger | Time |
| TimeStamp | TinyInteger |
| Unknown | UnsignedBigInteger |
| UnsignedInteger | UnsignedSmallInteger |
| UnsignedTinyInteger | VariableBinary |
| VariableCharacter | WideCharacter |
| WideLongVariableCharacter | WideVariableCharacter |
If this element is not specified, the default data type is Character.
See the examples in the PivotTable and QueryTable element topics.