利用SQL Server 2005数据库邮件发送电子邮件

EXEC msdb.dbo.sp_send_dbmail

@recipients=N'chapman.tim@gmail.com',
@body='Message Body', 

@subject ='Message Subject',
@profile_name ='DatabaseMailProfile',
@query ='SELECT Product FROM sb2..SalesHistory GROUP BY Product HAVING COUNT(*) > 3', 

@attach_query_result_as_file = 1,
@query_attachment_filename ='Results.txt'