请教一下与数据库中数据类型有关的问题,谢谢 在不同编程语言中定义的名称不同,但是对应的SQL Server中的数据库类型是相同的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 假设我调用DataTypeEnum CAdoRecordSet::GetFieldType(LPCTSTR lpszFieldName)得到类型为adLongVarChar ,我该调用第一组里的哪一个函数去得到其值? 楼主用的是:VC中的ADO与数据库连接吗?因为ADO中的类型与数据库中类型是一一对应的,但不是同一类型,比如在ADO中是adLongVarChar,在数据库可能是LongVarChar或LongVarChar。假设我调用DataTypeEnum CAdoRecordSet::GetFieldType(LPCTSTR lpszFieldName)得到类型为adLongVarChar ,我该调用第一组里的哪一个函数去得到其值?用:BOOL GetCollect(LPCSTR strFieldName, long &value); 请问数据库中的数据类型有以下类型中哪几种及组合? adEmpty = 0, adTinyInt = 16, adSmallInt = 2, adInteger = 3, adBigInt = 20, adUnsignedTinyInt = 17, adUnsignedSmallInt = 18, adUnsignedInt = 19, adUnsignedBigInt = 21, adSingle = 4, adDouble = 5, adCurrency = 6, adDecimal = 14, adNumeric = 131, adBoolean = 11, adError = 10, adUserDefined = 132, adVariant = 12, adIDispatch = 9, adIUnknown = 13, adGUID = 72, adDate = 7, adDBDate = 133, adDBTime = 134, adDBTimeStamp = 135, adBSTR = 8, adChar = 129, adVarChar = 200, adLongVarChar = 201, adWChar = 130, adVarWChar = 202, adLongVarWChar = 203, adBinary = 128, adVarBinary = 204, adLongVarBinary = 205, adChapter = 136, adFileTime = 64, adPropVariant = 138, adVarNumeric = 139, adArray = 8192 关于安装SOL Server 2008的问题 问一个关于记录想减的问题 求一条SQL语句,大家都进来帮忙看看 求一条有关最大值的语句,只包含限定字段 两表连接时,右表有对应的记录,只想取一条,SQL该怎么写? 主从表关系和更新问题 請問大俠們IDENTITY(int, 1, 2) 中的 1 (seed)可否為變量?? 关于数据库质疑如何导出数据的问题?? 怎样判断数据库中表已经存在 求问怎样查询两张表中不相同的记录 如何判断一个字段的内容在另一个字段中是否出现过,请求帮忙! 请问字符串字段大小有没有限制?最大多少字节?与BLOB有何不同?谢谢指教
假设我调用DataTypeEnum CAdoRecordSet::GetFieldType(LPCTSTR lpszFieldName)得到类型为adLongVarChar ,我该调用第一组里的哪一个函数去得到其值?
用:BOOL GetCollect(LPCSTR strFieldName, long &value);
adEmpty = 0,
adTinyInt = 16,
adSmallInt = 2,
adInteger = 3,
adBigInt = 20,
adUnsignedTinyInt = 17,
adUnsignedSmallInt = 18,
adUnsignedInt = 19,
adUnsignedBigInt = 21,
adSingle = 4,
adDouble = 5,
adCurrency = 6,
adDecimal = 14,
adNumeric = 131,
adBoolean = 11,
adError = 10,
adUserDefined = 132,
adVariant = 12,
adIDispatch = 9,
adIUnknown = 13,
adGUID = 72,
adDate = 7,
adDBDate = 133,
adDBTime = 134,
adDBTimeStamp = 135,
adBSTR = 8,
adChar = 129,
adVarChar = 200,
adLongVarChar = 201,
adWChar = 130,
adVarWChar = 202,
adLongVarWChar = 203,
adBinary = 128,
adVarBinary = 204,
adLongVarBinary = 205,
adChapter = 136,
adFileTime = 64,
adPropVariant = 138,
adVarNumeric = 139,
adArray = 8192