http://www.soaspx.com/dotnet/sql/mssql/sql2008/sqlserver2008_20100109_2287.html
Exec msdb.dbo.sp_send_dbmail @profile_name='David的配置邮件',
@ recipients=' it-2@zettler cn.com',
@subject='数据库邮件测试',
@body='这是从 ERP2010 上的数据库邮件发出的测试电子邮件!'
Exec msdb.dbo.sp_send_dbmail @profile_name='David的配置邮件',
@ recipients=' it-2@zettler cn.com',
@subject = '查询结果',
@body = '查询结果在附件中',
@query = 'select TOP 100 MB001,MB002,MB003 from ZE.dbo.INVMB',
@attach_query_result_as_file = 1,
@query_attachment_filename = 'a.txt'
@ recipients='
@subject='数据库邮件测试',
@body='这是从 ERP2010 上的数据库邮件发出的测试电子邮件!'
Exec msdb.dbo.sp_send_dbmail @profile_name='David的配置邮件',
@ recipients='
@subject = '查询结果',
@body = '查询结果在附件中',
@query = 'select TOP 100 MB001,MB002,MB003 from ZE.dbo.INVMB',
@attach_query_result_as_file = 1,
@query_attachment_filename = 'a.txt'