XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function.
2007-02-22
4,779 reads
Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains.
2007-02-20
3,813 reads
XML is becoming more and more prevalent in applications and more SQL Server DBAs are learning to work with this data structure. Raj Vasant brings us part 2 of his series on using OPENXML inside SQL Server, looking at passing XML into your stored procedures this time.
2006-02-16
8,376 reads
2005-05-30
1 reads
SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.
2007-10-02 (first published: 2005-05-12)
42,327 reads
Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000.
2001-05-10
6,082 reads
Full documentation on the Undercover Catalogue can be found HERE It’s been a while...
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
All, I'm trying to find a way to let some of our users see...
Hello, I have a script that was running really long, and I have found...
I am building a report to show customer journeys and their arrears levels. I...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers