A question on calling XML stored proceduresRSS

1 reply

Last post Jun 17, 2004 12:25 AM by Ken Schaefer

  • A question on calling XML stored procedures

    Jun 15, 2004 06:18 PM|pcdanno|LINK

    Hi, I know you can do this from ASP.NET but was wondering whether this can be done from ASP. I have an XML stored procedure in SQL Server 2000. My stored procedure uses the "for XML explicit" clause to output the results of a query as XML. In ASP.NET I can use an XMLReader and XMLDocument object to call my store procedure and store the results of the query as an XML document. Does ASP have any equivalent objects? If not, how does one go about generating an XML document from SQL Server 2000? Thanks
  • Re: A question on calling XML stored procedures

    Jun 17, 2004 12:25 AM|Ken Schaefer|LINK

    ASP doesn't have intrinsic objects to do this, but there are the MSXML classes that I assume you can use. Cheers Ken