Microsoft SQL Server 2000, the world’s fastest database, ships with built-in support for XML. Since the release of SQL Server 2000, Microsoft has released updates to keep SQL Server 2000 XML support current with evolving World Wide Web Consortium (W3C) recommendations and to introduce expanded functionality. Highlights of SQLXML are:
XML Views
Provide “virtual” XML document view over relational data
Support XPath queries and XML Updategrams
Support Bulk Import of large XML files
Automatic mapping supported; user can customize mapping using XML Schema (XSD) or XDR
Can be accessed over HTTP or using any COM-capable programming language
Adds “FOR XML” keywords to T-SQL to permit creation of XML directly from SQL queries
Adds “OPENXML” keyword to T-SQL to permit creation of SQL Server rowsets directly from XML