SQL Server Performance

Modifying an XML parameter

Discussion in 'SQL Server 2005 CLR' started by EMoscosoCam, Mar 23, 2008.

  1. EMoscosoCam Member

    Hello
    Suppose that I have a CLR Stored procedure that has an Input/Output parameter of type XML. Inside the stored procedure, this parameter's xml text is loaded into an XMLDocument object, so that I can manipulate the data using XPath and so forth. Now, I would like to return to the client the modified XML Text, but apparently the parameter's Value property does not allow changes, and I don't see a method that I could use.
    What can I do?
    Thanks a lot
  2. Luis Martin Moderator

    Check:
    http://taxi.sourceforge.net/transformationProcess/transformation/XMLtoGRP/howToFromConsole.html
    HTH

Share This Page