RE: Where to obtain the material to study the in-and-out of SQL Server



I would get a good understanding of XML first before working out how SQL
Server supports it.

Start here, at the excellent W3 Schools tutorials:

http://www.w3schools.com/xml/default.asp

As well as BOL, MSDN has some great articles and there is Jacob Sebastien's
site over on:

http://www.sqlserverandxml.com

Good luck!
wBob

"pedestrian via SQLMonster.com" wrote:

Besides Books Online, what are the resources to study the fundamental of SQL
Server XML feature? Is that necessary to study for basic XML course before
proceed to SQL Server 2005 XML feature?

Thank you very much.

--
Warmest Regards,
Pedestrian

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-xml/200810/1


.



Relevant Pages

  • Re: Duplicate Record with .ADDNEW
    ... If the database server will allow you to create a table without something, ... table there is no possibility of duplicate records. ... field imported from the XML. ... Use the Command object instead. ...
    (microsoft.public.vb.database.ado)
  • Re: openxml - streams the xml or loads it all in to memory?
    ... OpenXML does load it into its memory (although it will be using the SQL ... Server buffer and does has some disk backing). ... SQLXML 3.0 XML Bulkload facility. ...
    (microsoft.public.sqlserver.xml)
  • RE: XML iFilter needed for SPS 2003 infopath forms?
    ... did in fact need to be installed on the Sharepoint server, ... Apparently the claim that SP indexes xml files is not quite specific enough. ... It must use a default text Filter not a true xml ifilter. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Dataset or SqlCommand or SQLXML
    ... you can do it using the WriteXml method of a ... of SqlCommand - and this will only work with a FOR XML query against SQL ... Server 2000 - so you couldn't use this approach with other data sources. ... quite a few advantages to using the SqlXml classes if your data is in SQL ...
    (microsoft.public.sqlserver.xml)
  • Re: Help, Transferring XML data under SSL
    ... I hope that you are using SQL 2000 and then you can use the FOR XML things. ... Curl is free for download and it installs like ... The sql server will have curl installed on it. ...
    (microsoft.public.data.xmlanalysis)

Loading