Enum SqlDataType

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