类型：转载 责任编辑：asp.net 日期：2007/05/23
热门软件下载：
在调用存储过程时，怎么设置参数具体如下：
存储过程中的字段定义为(@contents ntext)
cmd1.parameters.append cmd1.createparameter("@contents",此参数该怎么定义,adparaminput,16,contents1)
感谢各位大侠!!!!
网友回答：
看这里的
adEmpty = "Empty"
adTinyInt = "TinyInt"
adSmallInt = "SmallInt"
adInteger = "Integer"
adBigInt = "BigInt"
adUnsignedTinyInt = "UnsignedTinyInt"
adUnsignedSmallInt = "UnsignedSmallInt"
adUnsignedInt = "UnsignedInt"
adUnsignedBigInt = "UnsignedBigInt"
adSingle = "Single"
adDouble = "Double"
adCurrency = "Currency"
adDecimal = "Decimal"
adNumeric = "Numeric"
adBoolean = "Boolean"
adError = "Error"
adUserDefined = "UserDefined"
adVariant = "Variant"
adIDispatch = "IDispatch"
adIUnknown = "IUnknow"
adGUID = "GUID"
adDate = "Date"
adDBDate = "DBDate"
adDBTime = "DBTime"
adDBTimeStamp = "DBTimeStamp"
adBSTR = "BSTR"
adChar = "Char"
adVarChar = "VarChar"
adLongVarChar = "LongVarChar"
adWChar = "WChar"
adVarWChar = "VarWChar"
adLongVarWChar = "LongVarWChar"
adBinary = "Binary"
adVarBinary = "VarBinary"
adLongVarBinary = "LongVarBinary"
adChapter = "Chapter"
adFileTime = "FileTime"
adPropVariant = "PropVariant"
adVarNumeric = "VarNumeric"
adArray = "Array"
帮你往上顶先！
ADO 与 SQL Sverver 数据类型的映射关系(收藏)
SQL Server Data Type ADO Data Type
bigint adBigInt
binary adBinary
bit adBoolean
char adChar
datetime adDBTimeStamp
decimal adNumeric
float adDouble
image adVarbinary
int adInteger
money adCurrency
nchar adWChar
ntext adWChar
numeric adNumeric
nvarchar adWChar
real adSingle
smalldatetime adTimeStamp
smallint adSmallInt
smallmoney adCurrency
sql_variant adVariant
sysname adWChar
text adChar
timestamp adBinary
tinyint adVarbinary
uniqueidentifier adGUID
varbinary adVarbinary
varchar adChar
http://archimond.mblogger.cn/posts/2730.aspx