如何将两个动态查询和两个文件作为附件发送DB Mail

CREATE PROCEDURE SendDBMailWithAttachments
AS
BEGIN
    -- 执行两个动态查询并保存结果到表变量
    DECLARE @Query1Result TABLE (Column1 INT, Column2 VARCHAR(50))
    DECLARE @Query2Result TABLE (Column1 INT, Column2 VARCHAR(50))

    INSERT INTO @Query1Result
    EXEC('SELECT Column1, Column2 FROM Table1')

    INSERT INTO @Query2Result
    EXEC('SELECT Column1, Column2 FROM Table2')

    -- 复制两个文件到指定目录
    EXEC xp_cmdshell 'xcopy "C:\Path\To\File1" "C:\Path\To\Destination"'
    EXEC xp_cmdshell 'xcopy "C:\Path\To\File2" "C:\Path\To\Destination"'

    -- 发送邮件
    EXEC msdb.dbo.sp_send_dbmail
        @profile_name = 'YourProfile',
        @recipients = 'recipient@example.com',
        @subject = 'Email Subject',
        @body = 'Email Body',
        @file_attachments = 'C:\Path\To\Destination\File1,C:\Path\To\Destination\File2',
        @query = 'SELECT * FROM @Query1Result; SELECT * FROM @Query2Result',
        @attach_query_result_as_file = 1,
        @query_attachment_filename = 'QueryResult.csv'
END