What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.
2018-07-11
2,712 reads
Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.
2017-01-16
4,226 reads
2016-10-13
1,235 reads
2015-07-13
1,545 reads
Getting rid of R-BAR to split a delimited string. This method is popular for it's simplicity, speed and zero reads.
2015-03-17 (first published: 2013-07-29)
4,787 reads
2013-07-29
2,181 reads
2012-06-07
2,003 reads
In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.
2012-03-14
15,993 reads
2012-01-27
2,235 reads
Second in the series of tools & techniques to help manage aspects Of Enterprise BI implementation.
2011-12-20
6,188 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers