Stairway to XML: Level 7 - Updating Data in an XML Instance

Posted on SQL Server Central See other posts from SQL Server Central
Published on Mon, 29 Oct 2012 06:00:00 UT Indexed on 2012/10/30 23:13 UTC
Read the original article Hit count: 381

Filed under:

You need to provide the necessary keywords and define the XQuery and value expressions in your XML DML expression in order to use the modify() method to update element and attribute values in either typed or untyped XML instances in an XML column. Robert Sheldon explains how.

"It really helped us isolate where we were experiencing a bottleneck"
- John Q Martin, SQL Server DBA. Get started with SQL Monitor today to solve tricky performance problems - download a free trial

Developer IT

Stairway to XML: Level 7 - Updating Data in an XML Instance - Developer IT

Stairway to XML: Level 7 - Updating Data in an XML Instance

Categories cloud