Browse by Tags

• auditing
• FLWOR
• function
• introduction
• logging
• methods
• programming
• SQL Server
• trigger
• tutorial
• XML
• XQuery

• Unmatched Nodes in XQuery

  In a previous entry I talked about simulating SQL inner joins with XQuery FLWOR expressions. In this post I'll take a look at finding unmatched nodes in two node sequences - a requirement for implementing outer join-style functionality in XQuery.... Posted Feb 25 2008, 12:53 AM by Mike C with | with no comments Filed under: XML, new features, tutorial, programming, SQL Server, FLWOR, XQuery, function

• Create a Dynamic Logging Trigger With XML

  Triggers are a useful tool for logging DML actions and auditing data changes to tables. But wouldn't it be great if you could write just one trigger and use it on any table? And if the table structure changed the trigger would automatically adjust with no work on your part? With FOR XML and catalog views we can do just that.... Posted Jan 26 2008, 08:47 PM by Mike C with | with no comments Filed under: XML, new features, programming, SQL Server, auditing, logging, trigger

• Welcome to Pro SQL Server XML

  Welcome to the Pro SQL Server XML (2005, 2008) blog. In this introductory blog, I provide a sample using the xml data type and the nodes() method to shred cached XML query plans on the server. This example demonstrates several new features in addition to the nodes() method, including CROSS APPLY, CTEs, dynamic management functions/views, and more.... Posted Jan 21 2008, 05:38 PM by Mike C with | with 1 comment(s) Filed under: XML, new features, methods, tutorial, introduction