请尝试以下解决方案。

它使用 SQL Server XQuery 功能。

此外，它还使用 CSS 来设置输出 XHTML 的样式。

SQL

-- DDL and sample data population, start DECLARE @tbl TABLE (test VARCHAR(100) PRIMARY KEY, result INT); INSERT @tbl (test, result) VALUES ('Bu', 57), ('Po', 5), ('Zu', 9); -- DDL and sample data population, end DECLARE @xhtmlBody XML , @body NVARCHAR(MAX) , @tableCaption VARCHAR(30) = 'Tests results report'; SET @xhtmlBody = (SELECT ( SELECT * FROM @tbl FOR XML PATH('row'), TYPE, ROOT('root')) .query('  (: including embedded CSS styling :)  
   { for $row in /root/row return  } 
 
{sql:variable("@tableCaption")}
 
 
 
Test Name
 
Formatted result
 
 
 
 
{data($row/test)}
 
 {if (($row/result/text())[1] lt 10) then attribute id {"red"} else ()} {data($row/result)} 
 
')); SELECT @xhtmlBody; SET @body = TRY_CAST(@xhtmlBody AS NVARCHAR(MAX));

输出XHTML

    
  
 
 
Tests results report
 
 
 
 
Test Name
 
Formatted result
 
 
 
 
 
Bu
 
57
 
 
 
Po
 
5
 
 
 
Zu
 
9