ASP Stored Procedure Parameter Data Type

Source: Internet
Author: User

ASP:
P. Append cmd. CreateParameter ("parameter name", type, direction, size)

The parameter value types 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

Note:
Ntext 203 adLongVarWChar
Text 201 adLongVarChar

In ASP, when a Command is used to call a stored procedure to add a record to a database, which type of parameter is used for ntext fields?
P. Append cmd. CreateParameter ("parameter name", 201, 1, 1073741823, cstr (value ))

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.