modify() Method (xml Data Type)
Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
Is a string in XML Data Manipulation Language (DML). The XML document is updated according to this expression.
An error is returned if the modify() method is called on a null value or results in a null value.