Processing XML files with SQL Server functions
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
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,931 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,365 reads
This article explores how we can import XML into SQL Server using a powerful open source tool called XMLStarlet
2008-10-09
10,639 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,035 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,853 reads
Longtime author Leo Peysakhovich brings us a new series on converting XML data into regular data. This article examines validating the XML data against a schema.
2009-07-03 (first published: 2008-08-25)
16,730 reads
This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.
2008-08-20
9,771 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers