SQL Server Performance

Modifying an XML parameter

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

  1. EMoscosoCam Member

    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


Share This Page