Aspose::Cells::ExternalConnections::SqlDataType enum

SqlDataType enum

Specifies SQL data type of the parameter. Only valid for ODBC sources.

enum class SqlDataType

Values

NameValueDescription
SqlUnsignedOffset-22
sql unsigned offset
SqlSignedOffset-20
sql signed offset
SqlGUID-11
sql guid
SqlWLongVarchar-10
sql wide long variable char
SqlWVarchar-9
sql wide variable char
SqlWChar-8
sql wide char
SqlBit-7
sql bit
SqlTinyInt-6
sql tiny int
SqlBigInt-5
sql big int
SqlLongVarBinary-4
sql long variable binary
SqlVarBinary-3
sql variable binary
SqlBinary-2
sql binary
SqlLongVarChar-1
sql long variable char
SqlUnknownType0
sql unknown type
SqlChar1
sql char
SqlNumeric2
sql numeric
SqlDecimal3
sql decimal
SqlInteger4
sql integer
SqlSmallInt5
sql small int
SqlFloat6
sql float
SqlReal7
sql real
SqlDouble8
sql double
SqlTypeDate9
sql date type
SqlTypeTime10
sql time type
SqlTypeTimestamp11
sql timestamp type
SqlVarChar12
sql variable char
SqlIntervalYear101
sql interval year
SqlIntervalMonth102
sql interval month
SqlIntervalDay103
sql interval day
SqlIntervalHour104
sql interval hour
SqlIntervalMinute105
sql interval minute
SqlIntervalSecond106
sql interval second
SqlIntervalYearToMonth107
sql interval year to month
SqlIntervalDayToHour108
sql interval day to hour
SqlIntervalDayToMinute109
sql interval day to minute
SqlIntervalDayToSecond110
sql interval day to second
SqlIntervalHourToMinute111
sql interval hour to minute
SqlIntervalHourToSecond112
sql interval hour to second
SqlIntervalMinuteToSecond113
sql interval minute to second

See Also