I'm using classic asp and I'm passing in a varchar (ado data type) into an xml data column in a proc.
The xml looks as follows:
<DocumentCriteria>
<Document documentGUID="{B49654E7-9AF2-4B89-AF8F-5146F7CD4911}" graderFYC="5907">
<criterion cnumber="1" rank="3"/>
<criterion cnumber="3" rank="3"/>
</Document>
</DocumentCriteria>'
I'd like to have a table that looks like this:
DocumentGUID|GraderFYC|Cnumber|Rank
{guid} | 5907 | 1 | 3
{guid} | 5907 | 3 | 3
How can I do this within a procedure? Is the adVarchar type okay in the ADO connection?