declare @address nvarchar(300),
@tableHTML nvarchar(max)
SET @tableHTML=N'<H1 align="center" style ="color:red">未维护</H1>' +
N'<table border="1">'
+ N'<tr>
<th>编号</th>
<th>部门</th>
<th>分析</th>
<th>措施</th>
</tr>'
+ CAST(( SELECT td = [rs].num ,'' ,
td = [rs].bm,'' ,
td = isnull([rs].Cause,''),'' ,
td = isnull([rs].Correction,'') ,''
FROM table1 AS [rs] where bm = @bm
FOR XML PATH('tr') , TYPE
) AS NVARCHAR(MAX)) + N'</table>'
EXEC msdb.dbo