RE: [xsl] Re: Microsoft XML

Subject: RE: [xsl] Re: Microsoft XML
From: "Joshua Allen" <joshuaa@xxxxxxxxxxxxx>
Date: Wed, 15 Aug 2001 12:59:33 -0700
Since you mention specifically that your customer has SQL Server 7.0 and
needs to interface with the relational, you might be interested to know
that the XML support that shipped with SQL Server 2000 has been updated
to support XSD schemas and has been updated to support XML against SQL
Server 7.0 databases.  (Although the version that supports SQL 7 is only
Beta 2 right now; full release later in the fall)  Relevant features
are:

* XML Views
  - Provide "virtual" XML document view over relational data
  - Support binary data directly (images, etc.) or as base64
  - Automatic XSLT transform
  - Support XPath queries and XML Updategrams
  - Support Bulk Load of large XML files
  - Automatic mapping supported; user can customize mapping using XSD or
XDR
  - Can be accessed over HTTP (or using any COM programming language)

* Adds "FOR XML" keywords to SQL to permit creation of XML directly from
SQL queries
* Adds "OPENXML" keyword to SQL to permit creation of SQL Server rowsets
directly from XML

Download at:
http://msdn.microsoft.com/msdn-files/027/001/602/search.asp

-----Original Message-----
From: Mark Galbreath [mailto:mgalbrea@xxxxxxxxxxxxxx] 
Sent: Wednesday, August 15, 2001 7:10 AM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] Re: Microsoft XML

As for my requirements, the client has a legacy SQLServer 7.0 databse.
The idea is to permit its web content authors to change text and
graphics through an admin interface based on XML templates that are
tranformed via XSLT to HTML.

Cheers!
Mark



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread