in

SQLServerCentral.com

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

Browse by Tags

  • XML Puzzle Contest Winners

    In the last entry I promised to share the answer to the XML puzzle today. Here's a quick recap of the question - SQL 2005 BOL gives the following example of a full-text search XML thesaurus file: <XML ID="Microsoft Search Thesaurus"> <thesaurus xmlns="x-schema:tsSchema.xml">...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 06-20-2008

  • 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

  • Inner Joins in XQuery

    One of the more interesting features of XQuery is FLWOR expressions (FLWOR stands for "for, let, where, order by, return", the keywords in the FLWOR expression vocabulary). FLWOR expressions have several capabilities, many of which are well-documented, but some of which get little attention...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 02-10-2008

  • Create a Dynamic Logging Trigger With XML

    One of the more common uses of triggers is to create data manipulation language (DML) logging functionality. Essentially you can intercept and log inserts, updates, and deletes to tables. In the simplest case it's enough to know that one of these operations has occurred on a table, the date/time...
    Posted to Pro SQL Server XML (Weblog) by Mike C on 01-26-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 (6 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems