본문 바로가기
Development/Visual Basic | VBScript | ASP

ADO DataType (SQL → ADO)

by Dev. Jkun 2012. 2. 4.
반응형

Data Type

ADO CreateParameter Type

BigInt

adBigInt

Binary

adBinary

TimeStamp

adBinary

Bit

adBoolean

Char

adChar

Money

adCurrency

SmallMoney

adCurrency

DateTime

adDate

SmallDateTime

adDBTimeStamp

Float

adDouble

UniqueIdentifier

adGUID

Identity

adInteger

Int

adInteger

Image

adLongVarBinary

Text

adLongVarChar

Ntext

adLongVarWChar

Decimal

adNumeric

Numeric

adNumeric

Real

adSingle

SmallInt

adSmallInt

TinyInt

adUnsignedTinyInt

VarBinary

adVarBinary

VarChar

adVarChar

Sql_Variant

adVariant

NVarChar

adVarWChar

Nchar

adWChar

반응형

댓글