sql server 多数据批量发送邮件



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