This example is the query used to send a formatted html by xp_sendmail:
-- to test send output to text or file c:\temp\1.htm
SET NOCOUNT ON
select '' AS []
SELECT
' ' AS [ ]
...
What is the purpose of this example? It fails with the message 'An object or column name is missing or empty. ... Aliases defined as "" or [] are not allowed. ...'
When I removed the first SELECT statement, I didn't get any formatted HTML. I suppose that HTML tags in the example got mixed up with HTML tags in the QotD page.
Carlo, could you please post a message with the proper example attached? 🙂