An Extensible Stylesheet Language (XSL) style sheet can be applied to the query results. When you execute a template using HTTP, you can specify an XSL file in these ways:<\/p>\n
If the XSL file is specified both in the template using sql:xsl<\/strong> and in the URL using the keyword xsl, the XSL style sheet specified in the template is applied to the results first, and then the XSL file specified in the URL is applied. Examples:<\/em><\/strong><\/p>\n In the following example, nwind<\/strong> is a virtual directory created using the IIS Virtual Directory Management for SQL Server utility, and template<\/strong> is the virtual name of template<\/strong> type defined when the virtual directory is created (any name can be given to a virtual name when it is created). For more information, see Using IIS Virtual Directory Management for SQL Server Utility.
\n<\/em><\/p>\n
\nA. Specify sql:xsl in a template to process the result
\nIn this example, a template includes a simple SELECT statement. The query result is processed according to the instructions in the XSL file specified using sql:xsl.<\/strong>
\n<?xml version =’1.0′ encoding=’UTF-8′?>
\n<root xmlns:sql=’urn:schemas-microsoft-com:xml-sql’
\nsql:xsl=’MyXSL.xsl’>
\n<sql:query>
\nSELECT FirstName, LastName FROM Employees FOR XML AUTO
\n<\/sql:query>
\n<\/root>
\nFor illustration purposes, the template<\/strong> (Template<\/strong>WithXSL.xml) is stored in the directory associated with the virtual nameFirstName<\/b> (template), of template type. The XSL file (MyXSL.xsl) is also stored in the same directory.
\nThis is the XSL file:
\n<?xml version=’1.0′ encoding=’UTF-8′?>
\n<xsl:stylesheet xmlns:xsl=”http:\/\/www.w3.org\/1999\/XSL\/Transform” version=”1.0″>
\n<xsl:template match = ‘Employees’>
\n<TR>
\n<TD><xsl:value-of select = ‘@FirstName’ \/><\/TD>
\n<TD><B><xsl:value-of select = ‘@LastName’ \/><\/B><\/TD>
\n<\/TR>
\n<\/xsl:template>
\n<xsl:template match = ‘\/’>
\n<HTML>
\n<HEAD>
\n<STYLE>th { background-color: #CCCCCC }<\/STYLE>
\n<\/HEAD>
\n<BODY>
\n<TABLE border=’1′ style=’width:300;’>
\n<TR><TH colspan=’2′>Employees<\/TH><\/TR>
\n<TR><TH >First name<\/TH><TH>Last name<\/TH><\/TR>
\n<xsl:apply-templates select = ‘root’ \/>
\n<\/TABLE>
\n<\/BODY>
\n<\/HTML>
\n<\/xsl:template>
\n<\/xsl:stylesheet><\/em><\/p>\n