Export (0) Print
Expand All
4 out of 17 rated this helpful - Rate this topic

modify() Method (xml Data Type)

Modifies the contents of an XML document. Use this method to modify the content of an xml type variable or column. This method takes an XML DML statement to insert, update, or delete nodes from XML data. The modify() method of the xml data type can only be used in the SET clause of an UPDATE statement.

modify (XML_DML)
XML_DML

Is a string in XML Data Manipulation Language (DML). The XML document is updated according to this expression.

Note Note

An error is returned if the modify() method is called on a null value or results in a null value.

Because the modify() method requires a string in the XML Data Manipulation Language (DML), the samples for modify() are contained in the topics that describe the XML DML statements. For these examples, see insert (XML DML), delete (XML DML) and replace value of (XML DML).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.