用SQL Server 2005发送邮件的功能
用SQL Server 2005发送邮件的功能
简略介绍SQL Server 2005发送邮件的功能
用SQL Server 2005发送邮件:
- EXEC msdb.dbo.sp_send_dbmail
- @profile_name = 'test',
- @recipients = 'test1@test.com;test2@test.com',
- --@recipients = 'test@test.com',
- @body = '用msdb.dbo.sp_send_dbmail测试发邮件,不用猜了,我是谦',
- @subject = '测试发邮件 sql查询',
- @query = ' select 表名=name,类型=case xtype when ''S'' then ''系统表'' else ''用户表'' end from sysobjects where xtype in(''U'',''S'') ',
- @attach_query_result_as_file = 1,
- @query_attachment_filename = 'Results.txt';
评论暂时关闭