XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases, this is the most efficient way to modify elements in an XML column, yet the techniques of using XML-DML have not been well, or simply, described - up until now. Robert Sheldon presents a practical workbench to show the various modify methods
2009-05-14
1,420 reads
2009-03-12
3,363 reads
Loading and processing XML files into SQL Server tables can be simple, thanks to a method that uses SQL Server functions and XPath expressions.
2009-03-02
2,790 reads
MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.
2009-02-25
3,954 reads
You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.
2009-01-28
2,188 reads
2008-10-20
2,382 reads
This article explores how we can import XML into SQL Server using a powerful open source tool called XMLStarlet
2008-10-09
10,701 reads
RSS feeds are becoming almost required for any type of data publication. SQL Server MVP Jacob Sebastian brings us the next installment of his XML Workshop series that looks at a series of T-SQL functions to generate the RSS formatted data.
2008-10-01
3,066 reads
Although current databases limit XML processing to linear XPath or XQuery queries, existing hierarchical database techniques enable far more complex queries using standard SQL.
2008-10-01
3,542 reads
Continuing with his series on loading and transforming XML data, Leo Peysakhovich shows how to create the generic process to perform the convesions.
2009-07-10 (first published: 2008-08-26)
12,926 reads
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers