SqlDataType enumeration
SqlDataType enumeration
Specifies SQL data type of the parameter. Only valid for ODBC sources.
The SqlDataType type exposes the following members:
Fields
| Field | Description |
|---|---|
| SQL_UNSIGNED_OFFSET | sql unsigned offset |
| SQL_SIGNED_OFFSET | sql signed offset |
| SQL_GUID | sql guid |
| SQL_W_LONG_VARCHAR | sql wide long variable char |
| SQL_W_VARCHAR | sql wide variable char |
| SQL_W_CHAR | sql wide char |
| SQL_BIT | sql bit |
| SQL_TINY_INT | sql tiny int |
| SQL_BIG_INT | sql big int |
| SQL_LONG_VAR_BINARY | sql long variable binary |
| SQL_VAR_BINARY | sql variable binary |
| SQL_BINARY | sql binary |
| SQL_LONG_VAR_CHAR | sql long variable char |
| SQL_UNKNOWN_TYPE | sql unknown type |
| SQL_CHAR | sql char |
| SQL_NUMERIC | sql numeric |
| SQL_DECIMAL | sql decimal |
| SQL_INTEGER | sql integer |
| SQL_SMALL_INT | sql small int |
| SQL_FLOAT | sql float |
| SQL_REAL | sql real |
| SQL_DOUBLE | sql double |
| SQL_TYPE_DATE | sql date type |
| SQL_TYPE_TIME | sql time type |
| SQL_TYPE_TIMESTAMP | sql timestamp type |
| SQL_VAR_CHAR | sql variable char |
| SQL_INTERVAL_YEAR | sql interval year |
| SQL_INTERVAL_MONTH | sql interval month |
| SQL_INTERVAL_DAY | sql interval day |
| SQL_INTERVAL_HOUR | sql interval hour |
| SQL_INTERVAL_MINUTE | sql interval minute |
| SQL_INTERVAL_SECOND | sql interval second |
| SQL_INTERVAL_YEAR_TO_MONTH | sql interval year to month |
| SQL_INTERVAL_DAY_TO_HOUR | sql interval day to hour |
| SQL_INTERVAL_DAY_TO_MINUTE | sql interval day to minute |
| SQL_INTERVAL_DAY_TO_SECOND | sql interval day to second |
| SQL_INTERVAL_HOUR_TO_MINUTE | sql interval hour to minute |
| SQL_INTERVAL_HOUR_TO_SECOND | sql interval hour to second |
| SQL_INTERVAL_MINUTE_TO_SECOND | sql interval minute to second |
