报表统计

CREATE proc P_WXM_XiaoMiTopic as DECLARE @tableHTML NVARCHAR(MAX) declare @mailList Ncarchar(max) set @mailList=.@.com

begin   set @tableHTML=N'<H1>标题</H1>'+   N'<table border="1">'+   N'<tr><th>名称</th><th>链接</th><th>标题</th><th>时间</th>'+ CAST((     SELECT td= a.S#,'',td=a.Sage,''td=a.Sname,'',td=a.Ssex,''     from Student a with(nolock)       FOR XML PATH('tr'),TYPE ) AS NVARCHAR(MAX))+ N'</table>';

end EXEC msdb.dbo.sp_send_dbmail @recipients=@mailList, @subject='名称',  @body=@tableHTML,  @body_format='HTML'