Have you received an XML file that must be migrated into a production database? Today’s workshop dives into an ad hoc method of processing relational datasets delivered in an XML file format.  Read more...

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.  Read more...

This is an example of joining two group nodes using openxml.. In case you have an xml field in the database that you may query  Read more...

Read more...

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.   Read more...

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.  Read more...

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.  Read more...

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.   Read more...

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.   Read more...

The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!   Read more...

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!   Read more...

Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.   Read more...

Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000.   Read more...