从两个不同的查询邮件发送两个不同的附件从SQL

问题描述：

我想从两个不同的查询附加两个不同的文件;这是我的代码，这是造成这个问题的标题中提到的错误：从两个不同的查询邮件发送两个不同的附件从SQL

EXEC msdb.dbo.sp_send_dbmail 
    @profile_name='MyTestMail 
    @body = @body, 
    @body_format ='HTML', 
    @recipients = '[email protected]', 
    @subject = @SBJ, 
    @importance = HIGH, 
    @sensitivity= Confidential, 
    @query = 'Select * from XXXXXXXX;', 
    @attach_query_result_as_file = 1, 
    @query_attachment_filename = 'X1.csv', 
    @query_result_separator=',', 
    @query_result_width =32767, 
    @query_result_no_padding=1, 
    @query = 'Select * from XXXXXXXX2;', 
    @attach_query_result_as_file = 1, 
    @query_attachment_filename = 'X2.csv', 
    @query_result_separator=',', 
    @query_result_width =32767, 
    @query_result_no_padding=1;

我可以成功发送一个文件作为附件从相同的代码，如果不是XXXXXXXX2重复查询。

的[试图找出如何发送与SP \ _send \ _dbmail多个文件附件]可能的复制（https://stackoverflow.com/questions/2518261/trying-to如何发送多文件附件与sp-send-dbmail） – MatSnow

@Matsnow我很抱歉令你失望，但我在这里寻找别的东西，我想发送两个文件作为单个电子邮件中两个不同查询的附件，而不保存在本地计算机上。 –

答

只有从文件系统连接时才能附加多个文件。请参考下面的语法 -

sp_send_dbmail [ [ @profile_name = ] 'profile_name' ] 
     [ , [ @recipients = ] 'recipients [ ; ...n ]' ] 
     [ , [ @copy_recipients = ] 'copy_recipient [ ; ...n ]' ] 
     [ , [ @blind_copy_recipients = ] 'blind_copy_recipient [ ; ...n ]' ] 
     [ , [ @from_address = ] 'from_address' ] 
     [ , [ @reply_to = ] 'reply_to' ] 
     [ , [ @subject = ] 'subject' ] 
     [ , [ @body = ] 'body' ] 
     [ , [ @body_format = ] 'body_format' ] 
     [ , [ @importance = ] 'importance' ] 
     [ , [ @sensitivity = ] 'sensitivity' ] 
     [ , [ @file_attachments = ] 'attachment [ ; ...n ]' ] 
     [ , [ @query = ] 'query' ] 
     [ , [ @execute_query_database = ] 'execute_query_database' ] 
     [ , [ @attach_query_result_as_file = ] attach_query_result_as_file ] 
     [ , [ @query_attachment_filename = ] query_attachment_filename ] 
     [ , [ @query_result_header = ] query_result_header ] 
     [ , [ @query_result_width = ] query_result_width ] 
     [ , [ @query_result_separator = ] 'query_result_separator' ] 
     [ , [ @exclude_query_output = ] exclude_query_output ] 
     [ , [ @append_query_error = ] append_query_error ] 
     [ , [ @query_no_truncate = ] query_no_truncate ] 
     [ , [ @query_result_no_padding = ] @query_result_no_padding ] 
     [ , [ @mailitem_id = ] mailitem_id ] [ OUTPUT ]

从两个不同的查询邮件发送两个不同的附件从SQL

相关推荐