SqlDataType enumeration

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

public enum SqlDataType


Name Value Description
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
SqlUnknownType 0 sql unknown type
SqlChar 1 sql char
SqlNumeric 2 sql numeric
SqlDecimal 3 sql decimal
SqlInteger 4 sql integer
SqlSmallInt 5 sql small int
SqlFloat 6 sql float
SqlReal 7 sql real
SqlDouble 8 sql double
SqlTypeDate 9 sql date type
SqlTypeTime 10 sql time type
SqlTypeTimestamp 11 sql timestamp type
SqlVarChar 12 sql variable char
SqlIntervalYear 101 sql interval year
SqlIntervalMonth 102 sql interval month
SqlIntervalDay 103 sql interval day
SqlIntervalHour 104 sql interval hour
SqlIntervalMinute 105 sql interval minute
SqlIntervalSecond 106 sql interval second
SqlIntervalYearToMonth 107 sql interval year to month
SqlIntervalDayToHour 108 sql interval day to hour
SqlIntervalDayToMinute 109 sql interval day to minute
SqlIntervalDayToSecond 110 sql interval day to second
SqlIntervalHourToMinute 111 sql interval hour to minute
SqlIntervalHourToSecond 112 sql interval hour to second
SqlIntervalMinuteToSecond 113 sql interval minute to second

See Also