This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Re: Microsoft XML
- To: <xsl-list at lists dot mulberrytech dot com>
- Subject: RE: [xsl] Re: Microsoft XML
- From: "Joshua Allen" <joshuaa at microsoft dot com>
- Date: Wed, 15 Aug 2001 12:59:33 -0700
- Cc: <mgalbrea at maximgroup dot com>
- Reply-To: xsl-list at lists dot mulberrytech dot com
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@maximgroup.com]
Sent: Wednesday, August 15, 2001 7:10 AM
To: xsl-list@lists.mulberrytech.com
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