XML in SQLServer 2005/2008

I am beginning to learn XML with SQLServer. If SQLXML delivered the features
in SQLServer 2000 and if it is deprecated in SQLServer 2005/2008 what
component
delivers the XML features in SQLServer 2005/2008.

Thanks,
grajee

The XML data type and XQuery methods do this in SQL Server 2005-8.

The XML data type and XQuery methods do this in SQL Server 2005-8. XML data
type supports XSD schema validation. SELECT...FOR XML is expanded. The XML
nodes method is a more lightweight version of OPENXML. INSERT SELECT....
FROM OPENROWSERT BULK... can import XML from a file. Because of .NET support
in 2005-8, you can also write function/procs using System.Xml.dll and
friends. XML content (but not tags) can be used with fulltext search.

What exactly were you looking for? ;-)

Cheers,
Bob Beauchemin
SQLskills

Bob,I am kicking myself for not having learnt XML in SQLServer 2000 itself as

Bob,

I am kicking myself for not having learnt XML in SQLServer 2000 itself as it
was much easier to understand since the scope was very limited. I just
started to learn XML and I ended up in learning it in SQLServer 2008.

As you already know, for a beginner, SQLServer 2008 offers huge number of
features and it can be quite intimidating. I just thought it would help me
learn better/faster if I started off from the XML implementation in
SQLServer 2000 and follow it through the evolution.

I was under the impression that SQLXML was a component of the back-end in
SQLServer 2000. Am I correct?


I found "Microsoft SQLXML 4.0 SP1" in the feature pack. Now is this a part
of the SQLServer back-end (which means it would go along with the SQLServer
Engine) or is it a Client Component that needs to be installed in every
developers workstation?
-------------------------------------- Microsoft SQL Server 2008 Feature
Pack, April 2009  -------------------------------------------------------
Microsoft SQLXML 4.0 SP1
SQLXML enables XML support for your SQL Server Database. It allows
developers to bridge the gap between XML and relational data. You can create
XML View of your existing relational data and work with it as if it was an
XML file. SQLXML allows you to:
Query relational database with XPath
Update relational data as if it was XML
Load XML into SQL Server
Query SQL Server OLEDB/ADO or .NET Framework Managed Classes
Microsoft SQLXML 4.0 SP1 provides support for new SQL Server 2008 data types
such as Date, Time, DateTime2 and DateTimeOffset.
-------------------------------------- Microsoft SQL Server 2008 Feature
Pack, April 2009  -------------------------------------------------------


Similarly is the "Microsoft Core XML Services" a part of SQLServer back-end
(which means it would go along with the SQLServer Engine) or is it a Client
Component that needs to be installed in every developers workstation?
-------------------------------------- Microsoft SQL Server 2008 Feature
Pack, April 2009  -------------------------------------------------------
Microsoft Core XML Services (MSXML) 6.0
Microsoft Core XML Services (MSXML) 6.0 is the latest version of the native
XML processing stack. MSXML 6.0 provides standards-conformant
implementations of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0.
In addition, it offers 64-bit support, increased security for working with
untrusted XML data, and improved reliability over previous versions of
MSXML.
-------------------------------------- Microsoft SQL Server 2008 Feature
Pack, April 2009  -------------------------------------------------------

Thanks,
rgn

SQLXML 4.0 is the continuation of the SQLXML releases from SQL Server 2000.

SQLXML 4.0 is the continuation of the SQLXML releases from SQL Server 2000.
However the URL-based access has been dropped. Where you would  install it
depends on which pieces you are using and why. Some pieces would be used on
a middle-tier server, others on client.

But, if you are going to SQL Server 2005-2008, I'd strongly suggest getting
up to speed on the (much more extensive) XML functionality in those
releases.

Cheers,
Bob

Where can I read more about these?

Where can I read more about these? Can you point me in the right
direction(books, blogs .... etc) ?  Information to create XML documents, XML
Schemas, XSLT transformation are every where but not info on these
internals.

rgn

I'd start with the SQL Server 2008 Books Online.

I'd start with the SQL Server 2008 Books Online.

Designing and Implementing Semistructured Storage
http://msdn.microsoft.com/en-us/library/bb522446.aspx
XQuery Language Reference
http://msdn.microsoft.com/en-us/library/ms189075.aspx
SQLXML 4.0 Programming Concepts
http://msdn.microsoft.com/en-us/library/ms171779.aspx

And go on from there.

Cheers,
Bob