当我从表中获取数据并设置为 xml 格式时，在存储过程中。我想在标签中设置背景颜色<td>

Question

当我解析 xml 格式的日期行时，根据 td 设置背景颜色

declare @xml1 xml    
SET @xml1 = CAST((select Region AS 'td','',
      [MTD Total] AS 'td','',
      [MTD] AS 'td','',
      [MTD Percentage] AS 'td','',
      [FTD Total] AS 'td','',
      [FTD] AS 'td','',
      [FTD Percentage] AS 'td',''
FROM #temp
FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))
select  @xml1

Answer 1

你应该要么

• 使用此函数创建 HTML 表
• 插入class属性并使用 CSS
• 对<td>类使用 CSS(如果可以全局设置(

如果你真的想继续上述操作，你可以尝试这样的事情：

declare @xml1 xml =
(   
select
      'blue' AS [td/@bgcolor], 
      Region AS 'td','',
      'red' AS [td/@bgcolor], 
      [MTD Total] AS 'td','',
      'white' AS [td/@bgcolor], 
      [MTD] AS 'td','',
      'green' AS [td/@bgcolor], 
      [MTD Percentage] AS 'td','',
      'yellow' AS [td/@bgcolor], 
      [FTD Total] AS 'td','',
      'black' AS [td/@bgcolor], 
      [FTD] AS 'td','',
      'blue' AS [td/@bgcolor], 
      [FTD Percentage] AS 'td',''
FROM #temp
FOR XML PATH('tr'),TYPE
);
select  @xml1

就像您可以引入一般style属性一样......