Createparameter parameter description (ASP)

 

Createparameter parameter description (ASP)

Createparameter parameter description (ASP) Cmd. createparameter ("parameter name", type, direction, size) Cmd. createparameter name, type, direction, size, Value The value of data type and its significance are as follows: NAME value integer function Addbtimestamp 135 Date and Time Data Type Addecimal 14 decimal integer Addouble 5 Double Precision small value Aderror 10 system error message Adguid 72 globally unique identifier (globally unique identifier) Addispath 9 com/OLE Automatic Object (Automation Object) Adinteger 3 4-byte signed integer Adiunknown 13 Com/OLE object Adlongvarbinary 205 large 2-byte value Adlongvarchar 201 large string value Adlongvarwchar 203 large unencoded string Adnumeric 131 decimal integer Adsingle 4 single precision Floating Point decimal point Adsmallint 2 2-byte signed integer Adtinyint 16 1-byte signed integer Adunsignedbigint 21 8-byte unsigned integer Adunsignedint 19 4-byte unsigned integer Adunsignedsmallint 18 2-byte unsigned integer Adunsignedtinyint 17 1-byte unsigned integer Aduserdefined 132 user-defined data type Advariant 12 OLE object Advarbinary 204 Double Byte variable value Advarchar 200 character variable value Advarchar 202 unencoded string variable value Adwchar 130 unencoded string The meaning of the direction value is as follows: NAME value integer function Adparaminput 1 allows data input to this parameter Adparamoutput 2 allows data to be output to this parameter Adparaminputoutput 3 allows data input and output to this parameter. Adparamreturnvalue 4 allows data to be returned from a subroutine to this parameter For more detailed resources, see SQL server documentation and IIS documentation resources.