MSSQL - 프로시져 parameters 정리

출처 : http://cocoaday.tistory.com

// 문자형식 예시 //프로시져 @NAME  varchar(50) .Parameters.Append .CreateParameter("@NAME",advarchar,adParamInput,50,DATA)    '//숫자형식 예시 '//프로시져 @NAME  int .Parameters.Append .CreateParameter("@NAME",adInteger,adParamInput,0,DATA)    '//OUTPUT 예시 '//프로시져 @NAME  varchar(100)  output .Parameters.Append .CreateParameter("@NAME",adVarChar,adParamOutput, 100)   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