TADOStoredProc and XML

From: bill (burbanovsky_at_customins.com)
Date: 03/29/05 

Date: Tue, 29 Mar 2005 11:58:29 -0600

Delphi 2005 SQL Server 8

Using the TADOStoredProc component I can pass an xml document as a input
string to a stored procedure. Using OPENXML I can access the values. This
works fine.

However, I am unable to return an xml string using the "For XML" syntax in a
stored procedure. Does anybody have an example of returning xml from a sql
server stored procedure to a delphi app?

Thank you.
Bill

Relevant Pages

  • Re: using OpenXML in T-sql?
    ... am not the most senior person in sql server programming, ... especially xml stuff. ... style string in place of an array without the additional ... >delimited strings and opts for the xml string instead. ...
    (microsoft.public.sqlserver.programming)
  • Re: using OpenXML in T-sql?
    ... If you subscribe to SQL Server Professional, ... He suggests you can pass an xml string to the sp (as opposed to an xml doc - values from array would be in an xml string) and use Openxml to retrieve the values in one call rather than looping through an array. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cannot fetch a row from OLE DB provider "BULK" for linked serv
    ... the top of my stored procedure in T-SQL by pointing to the XML file? ... have the procedure in SQL Server to have an nvarcharparameter ...
    (microsoft.public.sqlserver.programming)
  • Re: using OpenXML in T-sql?
    ... delimited strings and opts for the xml string instead. ... SQL Server and Arrays ... @ID1 INT, ...
    (microsoft.public.sqlserver.programming)
  • Re: RETURING XML AS A PARAMETER .NET
    ... the input directly to the stored procedure and all seems to look fine. ... The sp simply takes in an xml document and returns a response xml in ... // create a local string variable to pass in the xml ... // check to see if the connection is still open ...
    (microsoft.public.sqlserver.xml)