http://www.sqlservercentral.com/Content tagged OpenXML posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/OpenXML/usingopenxml/1881/2007/02/23http://www.sqlservercentral.com/articles/OpenXML/usingopenxml/1881/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.http://www.sqlservercentral.com/redirect/articles/2868/2007/02/22http://www.sqlservercentral.com/redirect/articles/2868/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.http://www.sqlservercentral.com/redirect/articles/2867/2007/02/20http://www.sqlservercentral.com/redirect/articles/2867/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. http://www.sqlservercentral.com/articles/OpenXML/usingopenxmlpartii/2275/2006/02/16http://www.sqlservercentral.com/articles/OpenXML/usingopenxmlpartii/2275/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. http://www.sqlservercentral.com/articles/OpenXML/usingopenxml/1881/2007/02/23http://www.sqlservercentral.com/articles/OpenXML/usingopenxml/1881/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! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart4/665/2004/04/23http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart4/665/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! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/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! http://www.sqlservercentral.com/articles/Advanced+Querying/queryingxmlfilesusingsql2000/822/2002/10/11http://www.sqlservercentral.com/articles/Advanced+Querying/queryingxmlfilesusingsql2000/822/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. http://www.sqlservercentral.com/redirect/articles/485/2001/10/29http://www.sqlservercentral.com/redirect/articles/485/Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000. http://www.sqlservercentral.com/articles/OpenXML/forxml/160/2001/05/10http://www.sqlservercentral.com/articles/OpenXML/forxml/160/