Updates of XML columns

To update entire documents in an XML column, you can use the SQL UPDATE statement. You can include a WHERE clause when you want to update specific rows. To update portions of XML documents, use the XMLMODIFY function with a basic XQuery updating expression.