XML in SQLServer 2005/2008
rgn
in SQLServer 2000 and if it is deprecated in SQLServer 2005/2008 what
component
delivers the XML features in SQLServer 2005/2008.
Thanks,
grajee
Bob Beauchemin
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
"rgn" <r...@discussions.microsoft.com> wrote in message
news:FC596E5E-A494-4C34...@microsoft.com...
Gopinath Rajee
I'm 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
"Bob Beauchemin" <no_bob...@sqlskills.com> wrote in message
news:Oo4$AiiaKH...@TK2MSFTNGP05.phx.gbl...
Bob Beauchemin
However the URL-based access has been dropped. Where you'd 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're 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
"Gopinath Rajee" <rgop...@hotmail.com> wrote in message
news:6ADD5F57-6ABB-4393...@microsoft.com...
Gopinath Rajee
direction(books, blogs .... etc) ? Information to create XML documents, XML
Schemas, XSLT transformation are every where but not info on these
internals.
rgn
"Bob Beauchemin" <no_bob...@sqlskills.com> wrote in message
news:#ZiSxzMb...@TK2MSFTNGP02.phx.gbl...
Bob Beauchemin
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
"Gopinath Rajee" <rgop...@hotmail.com> wrote in message
news:2A87C1E4-B9D7-4128...@microsoft.com...
>>> 009 -------------------------------------------------------
>>> 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
>>> 009 -------------------------------------------------------
>>>
>>>
>>> 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
>>> 009 -------------------------------------------------------
>>> 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