본문 바로가기

WEB/ASP

[ASP] 저장프로시저 사용시 parameters

MSSQL데이터형식

PARAMTER데이터형식

bigint

adBigint

binary

adBinary

bit

adBoolean

char

adChar

datetime

adDate

decimal

adDecimal

float

adSingle

int

adInteger

money

adCurrency

nchar

adChar

ntext

adLongVarChar

numeric

adNumeric

nvarchar

adVarChar

real

adSingle

smalldatetime

adDate

smallint

adSmallInt

smallmoney

adCurrency

sql_variant

adVariant

text

adLongVarChar 

timestamp

adDBTimeStamp

tinyint

adTinyInt

varbinary

adVarBinary

varchar

adVarChar









































사용 예

.Parameters.Append .CreateParameter("@NAME",advarchar,adParamInput,30, str)

'//혹은
.Parameters.Append .CreateParameter("@NAME",advarchar,adParamInput,30)
.Parameters("@NAME") = str