In-depth discussion of SQL Server 2000 support for XML (i)

We can simply use ADO to access the data in the database, but if we want to display the data retrieved from the database in XML format
It's going to cost a bit of God, of course, and we can do that by looking for off-the-shelf apps or modifying existing stored procedures.
Although ADO2.5 claims to support XML, it still needs an extra layer to handle the process of translating data into XML. Luckily, with SQL Server 2000, it
Claims to be able to extract data directly from the database without ADO2.5 the data directly to the XML presentation. This feature greatly improves the construction of distributed,
The performance of applications in a dataset because this feature eliminates unnecessary layers of code.
Let's take a look at what new features are added to support Xml,sql Server 2000:
1. Ability to access SQL Server using HTTP.
2. Supports XDR (XML data simplification) schemas and the ability to specify XPath queries for these schemas.
3. Ability to retrieve and write XML data:
Retrieves XML data using the SELECT statement and the FOR XML clause.
Writes XML data using the OPENXML rowset provider.
Retrieves XML data using the XPath query language.
4. Enhanced Microsoft SQL Server OLE DB provider (SQLOLEDB), which enables you to set the XML document to command text and stream
Returns the result set in the form.
Visible, we can use SQL Server 2000来 to access XML-formatted data in several ways: first, queries executed in URLs can be directly
Access SQL Server 2000 to generate an XML document (you can also invoke an XML template that is stored on a Web server to generate an XML data file). The second type can be used
The Select command and the FOR XML keyword to obtain XML data by invoking a stored procedure or by using an XPath query. SQL Server 2000 fully supported
A schema with XDR (XML data simplification) with the ability to map XML elements and attributes to tables and fields. Next, I'll explore SQL Server 2000 FOR XML
's support features.
An IIS virtual directory that configures SQL Server 2000
At the beginning of this article, I'd like to talk about configuring the IIS virtual directory for SQL Server 2000. SQL Server 2000 allows you to create a virtual mesh for IIS
Record, which is used to directly access data in an SQL database. Once you have installed SQL Server 2000 on a computer that has IIS configured, you can run SQL
Server's IIS virtual Directory Management utility to configure the IIS virtual directories for SQL Server 2000.
OK, let's start the configuration process!
Click Configure SQL XML support in IIS in the SQL Server Tools program group, and an interface similar to IIS Manager appears. Show