XML and the SQL 2000 Server, Part 1

(Page 1 of 4 )

In this second article in a series, IIS XML support for SQL 2000 Server is explored.

Introduction

This tutorial explores the IIS XML support for SQL 2000 Server. By configuring a virtual root on Microsoft Internet Information Services, data from a SQL 2000 server can be accessed using XML over HTTP, the details of which will be examined in another article. This is possible because of the native support for XML in SQL 2000 Server.

SQL 2000 Server provides T-SQL language extensions to operate bi-directionally with relational and XML sources (see the first picture in this article). It also provides two system stored procedures, sp_XML_preparedocument and sp_XML_removedocument, that assist the XML to Relational transformation. SQL 2000 server's XML access capabilties are further enhanced with SQLXML 3.0, which allows XML formatting both on the client and the server. Prior to SQLXML 3.0 XML, formatting was on the server.

SQL Server is limited to mainly structured hierarchical and relational data, limited by absence of document storge facilities, and limited query capabilites (refer to BOL for restrictions in using For XML, for example) among others. SQL 2005 has many nice features, such as a brand new datatype called XML, available in both Typed and untyped varieties; the possibility of mixing relational and XML data; Querying XML and relational data; user defined functions with XML; and many others. Make time to attend this excellent Web seminar (author: Shanker Pal, Program Manager, Microsoft) to hear about it from the horse's mouth (http://www.microsoft.com/seminar/events/webcasts/default.mspx). The following aspects of XML support for SQL 2000 will be discussed in this article:

•    T-SQL support for for XML
  • Retrieving Data in XML formats, for XML
  • From XML document to Table structure, open XML
    
    
•    Overview of XML support in IIS for SQL 2000 Server
  
  
•    Configuring the IIS Virtual Directory Management for SQL 2000 Server
  
  
•    Summary

Next: T-SQL support for for XML >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: XML and the SQL 2000 Server, Part 1

· Cool, I did not know that this was possible!Verry nice.ThanxxBjorn    · If you liked the article, please look out for Part 2 on XML over HTTP, Part 3 on XML...    · Can you tell me if there is any way to have SQL Server 2005 to use a SELECT...    · Even in SQL 2005 the result of a select statement with a for xml auto clause...    · Hi,I am trying with sqlxml with MSQSL server2000 in Windows2003 os.Executed...   >>> Post your comment now!