in

SQLServerCentral.com

The largest free SQL Server community.

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
  • 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
Page 1 of 1 (2 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems