Welcome to MSDN Blogs Sign in | Join | Help

June 2005 - Posts

Performing XSLT Transforms on XML Data Stored in SQL Server 2005

A common task when dealing with XML data is to apply an XSLT style-sheet to the raw XML data in order to display it better. In a previous post to this blog, I showed how to append a processing instruction to your XML data in order to get IE to do the
Posted by mrorke | 3 Comments

Serialization and Concatenating String Values

A common requirement for an XML based application is the ability to do some form of simple string building. For example, the following query outputs a set of elements whose values are built up as a string, depending on some other value that is passed
Posted by mrorke | 0 Comments

Efficient Property Promotion from XML Instances (Part 2)

Last week I covered the basics of property promotion i.e. automatically extracting data from an XML instance and storing this as relational data in order to improve query readability and/or performance. If you missed this previous post, you can access
Posted by mrorke | 1 Comments
 
Page view tracker