O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

XML with SQL Server 2000

XML support is one of the new features of SQL Server 2000 (and Microsoft Data Engine [MSDE] 2000). The supported XML functions include the following:

  • The option to access SQL Server queries and procedures using Hypertext Transfer Protocol (HTTP) with a uniform resource locator (URL). The system returns the results in XML.

  • The option to read and generate XML data with commands such as OPENXML.

  • Support of XML Data Reduced (XDR), a proprietary Microsoft XML schema standard environment (also known as XSD). W3C has recommended XML schema since May 2001.

  • Support for XSD with SQLXML 2.0 download.

  • The SQL Server 2000 object linking and embedding database (OLE DB) provider and ADO were expanded, so that the system can now process ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required