in

SQLServerCentral.com

The largest free SQL Server community.
All Tags » SQL Server » tutorial (RSS)

Browse by Tags

  • Unmatched Nodes in XQuery

    In a previous post I talked about performing "inner joins" in XQuery. The basic idea is that the inner join is simply a special case of a Cartesian product, or "cross join". In this post I'm going to briefly look at another common SQL-style join condition that can be duplicated...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 02-24-2008

  • Retrieving Recursive Hierarchical Data

    Part of the promise of XML is that it makes modeling hierarchical data relatively painless. The hierarchical structure of XML automatically provides context to your data. Consider the following simple example: < General name = " Grant " > < Colonel name = " Sanders " >...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 02-15-2008

  • Loading XML From the File System

    SQL Server has a handy option for loading XML data directly from the file system, the OPENROWSET function. To load XML files into SQL Server, simply declare an xml data type variable and assign it the value of the OPENROWSET function with the BULK option. Here's a quick example that uses the state...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 02-04-2008

  • Xml Data Type: nodes() Method

    I've decided to kick this blog off with a double-feature. In the last post I gave an example of shredding XML query plans with the nodes() method. In this one we'll discuss the nodes() method in a little more detail. In a previous post on the Pseudo-Random blog, I recommended that everyone who's...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 01-22-2008
Page 1 of 1 (4 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems