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.sp_send_dbmail                                                               
    @profile_name = 'db_mail',
    @recipients =@address,
 @copy_recipients= '[e-mail]',
 @subject=N'未维护',
    @body = @tableHTML,
 @body_format='HTML';