Sign in
|
Join
|
Help
in
Current Tags
Pro SQL Server XML
SQLServerCentral.com Active...
(Entire Site)
SQLServerCentral.com
The largest free SQL Server community.
Home
Blogs
This Blog
Home
Contact
Syndication
RSS
Atom
Comments RSS
Recent Posts
XML Puzzle Contest Winners
XML Puzzle
Grabbing Node Names and Values Pt. 2
Grabbing Node Names and Values
Unmatched Nodes in XQuery
Tags
auditing
bill of materials
book
bulk load
contest
development
FLWOR
free
function
introduction
logging
methods
namespaces
new features
OPENROWSET
programming
shredding
SQL Server
trigger
tutorial
URI
XML
XQuery
News
SQL Server 2008 "Katmai" CTP 6 is available now at
https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395
and AdventureWorks sample database is available at
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=10901
! SQL Server 2008 RTM date has been pushed back to 3Q 2008.
Archives
June 2008
(1)
May 2008
(1)
March 2008
(2)
February 2008
(4)
January 2008
(3)
Pro SQL Server XML
SQL Server + XML Development Tutorials, Tips, and Tricks
Browse by Tags
All Tags
»
new features
(
RSS
)
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
Copyright Red Gate Software