Adding a Style-sheet Declaration to your XML Output

posted by  mneon (8)  10 months ago (blogs.msdn.com)

A common requirement for formatting XML output from XQuery expressions, is to be able to add a style-sheet declaration. Style-sheet declarations consist of a standard processing-instruction node that appears at the top-level of the XML. In the following example, we are attempting to construct a PI node, then select a peice of XML that will make up the body of the result:

declare @x xml
set @x='<myXML/>'

select @x.query('
<?xml-stylesheet type="text/xsl" href="my-style-sheet.xsl" ?>
/.
')

But, when you try and execute this query, you receive the following error