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= 'jay@qq.com',  @subject=N'未维护',     @body = @tableHTML,  @body_format='HTML';