http://www.sqlservercentral.com/Articles tagged XML, XSL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.http://www.sqlservercentral.com/articles/SSIS/62678/2008/04/23http://www.sqlservercentral.com/articles/SSIS/62678/Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page. http://www.sqlservercentral.com/articles/XSL/2831/2008/01/28http://www.sqlservercentral.com/articles/XSL/2831/Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application. http://www.sqlservercentral.com/articles/Security/3179/2007/08/20http://www.sqlservercentral.com/articles/Security/3179/Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page. http://www.sqlservercentral.com/articles/XSL/2831/2008/01/28http://www.sqlservercentral.com/articles/XSL/2831/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/This article introduces TSQLDoc, a Windows Script Host script that extracts procedure metadata and embedded documentation comments from Transact-SQL stored procedures, generates XML documentation for every stored procedure in a database and optionally transforms the XML document into HTML or other format using XSLT. http://www.sqlservercentral.com/articles/Stored+Procedures/tsqldoc/678/2002/08/09http://www.sqlservercentral.com/articles/Stored+Procedures/tsqldoc/678/SQLXML 3.0 beta adds new functionality to SQL Server 2000, giving developers the capability to expose stored procedures and XML templates as Web Services. It also includes all the features of SQLXML 1.0 and 2.0.http://www.sqlservercentral.com/redirect/articles/568/2002/01/01http://www.sqlservercentral.com/redirect/articles/568/Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base. http://www.sqlservercentral.com/redirect/articles/485/2001/10/29http://www.sqlservercentral.com/redirect/articles/485/