프로시져 사용시 ADO타입

MS-SQL 2010. 10. 6. 14:48 Posted by Dayis
 
ADO
DataType
Enum
ADO
DataType
Enum
Value
.NET
Framework
Visual
Basic
6.0
Access SQL
Server
Oracle
adBigInt 20 Int64
SqlInt64

BigInt
Variant   BigInt  
adBinary 128 Byte[]
SqlBinary

Binary
Variant   Binary
TimeStamp
Raw
adBoolean 11 Boolean
SqlBoolean

Boolean
Boolean YesNo Bit  
adBSTR 8 String
BSTR
       
adChapter 136 (DataReader)        
adChar 129 String 
SqlString

Char
String   Char Char
adCurrency 6 Decimal
SqlMoney

Currency
Currency Currency Money
SmallMoney
 
adDate 7 DateTime
Date
Date DateTime    
adDBDate 133 DateTime
DBDate
       
adDBFileTime 137 DBFileTime        
adDBTime 134 DateTime
DBTime
       
adDBTimeStamp 135 DateTime
SqlDateTime

DBTimeStamp
Date DateTime Datetime
 SmallDateTime
Date
adDecimal 14 Decimal
Decimal
Variant     Decimal
adDouble 5 Double
SqlDouble

Double
Double Double Float Float
adEmpty 0 Empty        
adError 10 External-Exception
Error
       
adFileTime 64 DateTime
Filetime
       
adGUID 72 Guid 
SqlGuid

Guid
Variant ReplicationID UniqueIdentifier  
adIDispatch 9 Object
IDispatch
       
adInteger 3 Int32
SqlInt32

Integer
Long  AutoNumber
 Integer
Long

Identity
Int

Int
adIUnknown 13 Object
IUnknown
       
adLongVarBinary 205 Byte[]
SqlBinary

LongVarBinary
Variant OLEObject Image Long Raw
Blob
adLongVarChar 201 String
SqlString

LongVarChar
String Memo
Hyperlink
Text Long
Clob
adLongVarWChar 203 String
SqlString

LongVarWChar
String Memo
Hyperlink
NText NClob
adNumeric 131 Decimal
SqlDecimal
Numeric
Variant Decimal Decimal
Numeric
Decimal
Integer
Number
SmallInt
adPropVariant 138 Object
PropVariant
       
adSingle 4 Single
SqlSingle

SIngle
Single Single Real  
adSmallInt 2 Int16,
SqlInt16

SmallInt
Integer Integer SmallInt  
adTinyInt 16 Byte
TinyInt
       
adUnsignedBigInt 21 UInt64
UnsignedBigInt
       
adUnsignedInt 19 UInt32
UnsignedInt
       
adUnsignedSmallInt 18 UInt16
UnsignedSmallInt
       
adUnsignedTinyInt 17 Byte
SqlByte
UnsignedTinyInt
Byte Byte TinyInt  
adUserDefined 132          
adVarBinary 204 Byte[] 
SqlBinary

VarBinary
Variant ReplicationID VarBinary  
adVarChar 200 String
SqlString
VarChar
String Text VarChar VarChar
adVariant 12 Object
Variant
Variant   Sql_Variant VarChar2
adVarNumeric 139 VarNumeric        
adVarWChar 202 String
SqlString

VarWChar
String Text NVarChar NVarChar2
adWChar 130 String
SqlString

WChar
String   NChar  

'MS-SQL' 카테고리의 다른 글

MS-SQL 인덱스 조각모음  (0) 2013.01.03
MS-SQL 전체 테이블 크기 조회 (용량순, 테이블이름순)  (0) 2012.08.16
declare cursor  (0) 2012.06.12
Join절 Update  (0) 2011.11.03
join, update  (0) 2010.11.22