http://www.sqlservercentral.com/Content tagged OpenXML, Basics posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/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/