SQL SERVER TYPES, COMPATIBLE Sql* TYPES, AND GetSql* METHODS

Posted on by coder
image_pdfimage_print
   


SQL SERVER TYPE    Sql* TYPE             GetSql* METHOD

bigint             SqlInt64              GetSqlInt64()

int                SqlInt32              GetSqlInt32()

smallint           SqlInt16              GetSqlInt16()

tinyint            SqlByte               GetSqlByte()

bit                SqlBoolean            GetSqlBoolean()

decimal            SqlDecimal            GetSqlDecimal()

numeric            SqlDecimal            GetSqlDecimal()

money              SqlMoney              GetSqlMoney()

smallmoney         SqlMoney              GetSqlMoney()

float              SqlDouble             GetSqlDouble()

real               SqlSingle             GetSqlSingle()

datetime           SqlDateTime           GetSqlDateTime()

smalldatetime      SqlDateTime           GetSqlDateTime()

char               SqlString             GetSqlString()

varchar            SqlString             GetSqlString()

text               SqlString             GetSqlString()

nchar              SqlString             GetSqlString()

nvarchar           SqlString             GetSqlString()

ntext              SqlString             GetSqlString()

binary             SqlBinary             GetSqlBinary()

varbinary          SqlBinary             GetSqlBinary()

image              SqlBinary             GetSqlBinary()

sql_varient        object                GetSqlValue()

timestamp          SqlBinary             GetSqlBinary()

uniqueidentifier   SqlGuid               GetSqlGuid()