sp_send_dbmail set 2 queries for the @query parameter

all

May i ask is it possible to set two queries for the stored procedure sp_send_dbmail?

  • Force SET IDENTITY_INSERT to take effect faster from MS Access
  • Triggers in SQL Server
  • SQL Server 2012 : extract Regex groups
  • SQL Server Convert a number
  • Constraint for only one record marked as default
  • SQL Duplicate Key Help
  • For example:

    EXEC msdb.dbo.sp_send_dbmail  
    @profile_name = 'example',  
    @recipients = 'example@XXX.com',  
    @query = 'Select * from table1; Select * from table2;',  
    @subject = 'Example',  
    @attach_query_result_as_file = 1 ;  
    

    Since most of the example from the internet only contain one query for the @query parameter.

    May i ask will the above code causing error?

    Thanks a lot !!


    EDIT:

    After deployment, the script was result in error for the @query parameter defined.

    The error message is shown below

    Error formatting query, probably invalid parameters [SQLSTATE 42000] (Error 22050). The step failed.

    Solution:

    Notice that when defining @query, the table should be in full path,

    Hence:

    @query = ‘Select * from [YOUR_SERVER_NAME].[dbo].table1; Select * from [YOUR_SERVER_NAME].[dbo].table2;’,

  • Stored procedure using sp_send_dbmail to send emails to multiple recipients queried from database
  • Using sp_send_dbmail with recieptent and content from single sql row
  • Stored procedure using SP_SEND_DBMAIL sending duplicate emails to all recipients
  • How can I use sp_send_dbmail to send multiple queries?
  • sp_send_dbmail executed from job fails with query result attached as file
  • sp_send_dbmail will not send query results
  • One Solution collect form web for “sp_send_dbmail set 2 queries for the @query parameter”

    I tried .
    It did work, but the result was in same file. Not sure if thats what you want.
    Plus the number of rows is also an issue. Or error as follows is shown:

     Msg 22050, Level 16, State 1, Line 0
    File attachment or query results size exceeds allowable value of 1000000 bytes.
    
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.