我有一个脚本可以发送一封电子邮件,该邮件的正文中包含一个html表。我想将此表中的总行设为粗体。要确定该行,在这里Col1中的值为“总计”-有任何想法吗?
declare @Tabletail nvarchar(max) = '</table></body></html>'
declare @TableHead nvarchar(max) = '<html><head>' + '<style>'
+ 'td {border: solid black;border-width: 1px;padding-left:5px;padding-right:5px;padding-top:1px;padding-bottom:1px;font: 11px arial} '
+ '</style>' + '</head>' + '<body>'
+ ' <br> <table cellpadding=0 cellspacing=0 border=0>'
+ '<tr> <td bgcolor=#00405A><font color="white"><b>col header 1</b></font></td>'
+ '<td align="right" td bgcolor=#00405A><font color="white"><b>col header 2</b></font></td>'
+ '<td align="right" td bgcolor=#00405A><font color="white"><b>col header 3</b></font></td>'
+ '<td align="right" td bgcolor=#00405A><font color="white"><b>col header 4</b></font></td>'
+ '<td align="right" td bgcolor=#00405A><font color="white"><b>col header 5</b></font></td>'
+ '<td align="right" td bgcolor=#00405A><font color="white"><b>col header 6</b></font></td></tr>'
declare @Body nvarchar(max) = (
select
td = Col1,'',[td/@align]='right',td = Col2,td = format(Col3,'0,##0'),td = format(Col4,td = format(Col5,td = format(Col6,''
from
#OutputTable
order by
RowNumber desc
FOR XML PATH('tr'),ELEMENTS
)