RE: XML With SQL Server

	I'm currently using version 7 but we have 2000 on standby which we're
setting up on a testserver next week to learn what it's capable of.

>For example, you can do an XML query within a url and send the results to
an XML stylesheet.

	Sounds like exactly what I was hoping for, thanks for the Book
recommendation - I'll order a copy and see what I can learn.....although I
may have to reinforce my bookshelf in the immediate future - it's getting a
little weighty :)

	At the moment we're using VB COM+ Components to translate recordsets into
XML which our ASP pages are then rendering with XML stylesheets however if
SQL2000 can return XML of its own then we can cut out the translation
process in the component and that has to be better for performance.

Mike,
Web Developer
Clockworx
www.clockworx.co.uk


-----Original Message-----
From: owner-hwg-xml(at)hwg.org [mailto:owner-hwg-xml(at)hwg.org]On Behalf Of
Michael Nunn-Weinberg
Sent: 15 March 2001 13:28
To: hwg-xml(at)hwg.org
Subject: RE: Is anyone subscribed to this list besides me?


Mike,

Which version of SQL Server are you using? I have been doing some work with
SQL Server 2000 and the XML
capabilities are quite impressive. For example, you can do an XML query
within a url and send the results to an XML stylesheet.
I found Professional SQL Server 2000 Programming by Rob Viera (Wrox) to be
an excellent book to learn more about this.

Regards,
Michael Nunn-Weinberg
President
Toronto SQL Server Users Group
www.tssug.org


-----Original Message-----
From: Mike Furmedge [mailto:mike(at)clockworx.co.uk]
Sent: Thursday, March 15, 2001 7:09 AM
To: hwg-xml(at)hwg.org
Subject: RE: Is anyone subscribed to this list besides me?



	Hi Kynn, I've just emptied Amazon's bookshelf on XML reference texts
and
will be spending the next few weekends getting up to speed on the basics -
my primary interest in XML is because I use Com components in my websites to
return data from SQL Server and I'd like to use XSL stylesheets to reformat
that data to display it in different ways - e.g for a shopping basket or an
order summary for instance - I could use the same call to the database to
retrieve the data but display it differently for those two pages.

	So basically my interest is to make my COM components more reusable
by
using XSL stylesheets with them, that and the whole versatility of XML looks
absolutely fascinating :)

Mike

HWG hwg-xml mailing list archives, maintained by Webmasters