[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