SQL/T-SQL - April 2016

Create XML/HTML with T-SQL

Generating XML/HTML output in SQL Server
Sending email from SQL is not a difficult to achieve, but generating rich HTML content might be. SQL Server itself is not built as a text processor, first approach would be to build HTML by simple concatenating the string elements. This approach will work, but over time it will become more and more difficult to maintain especially if you need to add layout elements over time. ... read more