<div>
<div class="content wysiwyg-content">
I need to send a parameter of type xml to a stored procedure on an asp(classic) page. 
What is the DataTypeEnum Value for xml type? 
 
This is the string to be sent: 
&quot;&lt;StudyDataList&gt;&lt;StudyData&gt;&lt;StudyParID&gt;931&lt;/StudyParID&gt;&lt;TPID&gt;2732&lt;/TPID&gt;&lt;DataValue&gt;1&lt;/DataValue&gt;&lt;/StudyData&gt; 
&lt;StudyData&gt;&lt;StudyParID&gt;931&lt;/StudyParID&gt;&lt;TPID&gt;2733&lt;/TPID&gt;&lt;DataValue&gt;2&lt;/DataValue&gt;&lt;/StudyData&gt; 
&lt;StudyData&gt;&lt;StudyParID&gt;931&lt;/StudyParID&gt;&lt;TPID&gt;2734&lt;/TPID&gt;&lt;DataValue&gt;3&lt;/DataValue&gt;&lt;/StudyData&gt; 
&lt;/StudyDataList&gt;&quot; 
 
Thanks
</div>
</div>

I need to send a parameter of type xml to a stored procedure on an asp(classic) page.
What is the DataTypeEnum Value for xml type?

This is the string to be sent:
"<StudyDataList><StudyData><StudyParID>931</StudyParID><TPID>2732</TPID><DataValue>1</DataValue></StudyData>
<StudyData><StudyParID>931</StudyParID><TPID>2733</TPID><DataValue>2</DataValue></StudyData>
<StudyData><StudyParID>931</StudyParID><TPID>2734</TPID><DataValue>3</DataValue></StudyData>
</StudyDataList>"

Thanks

How to append parameter of xml type in asp(classic)

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).