Stack Overflow
Stack Overflow

Questions tagged [xml-dml]

The XML Data Modification Language (XML DML) used Microsoft SQL Server 2005 and above to manipulate data in an XML field.

XML Data Modification Language (XML DML) is an extension of the XQuery language. XML-DML keywords include - insert - delete - replace value of

XML DML is similar to Oracle XU (XQuery Update).

63 questions
0
votes
2 answers

How do I modify a xml attribute in a xml field of a Sql Server table

I'm trying to update a XML column in a SQL Server table using the XML.modify replace value of (XML DML) With the below XML example, is there a way I can replace all vendorId with value 1 into another value? From the documentation in…
Ganesh
  • 245
  • 1
  • 9
0
votes
1 answer

Delete multiple XmlData sibling nodes with .remove()

This question is along the lines of Deleting Multiple Nodes in Single XQuery for SQL Server. The difference is that I want to indiscriminately remove all nodes within the document. XML: …
Matt R
  • 2,577
  • 5
  • 30
  • 46
0
votes
1 answer

Can't modify XML node's value in T-SQL (ms sql)

I would like to modify my xml's node value in mssql, but my approach doesn't seem to work. Here is an xml sample: John Smith ABC\jsmith …
mrtn
  • 45
  • 1
  • 4
1 2 3 4
5