How do you send a query result as an email Excel attachment in SQL Server?

Question

send email with excel attachment using sql stored procedure DECLARE @Body VARCHAR(8000) DECLARE @Qry varchar(8000) SET @Body ='Hi PFA,' SET @Qry='set nocount on;select * from tblname' DECLARE. @tab char(1) = CHAR(9) EXEC msdb.dbo.sp_send_dbmail. @profile_name = 'Profilename' ,

How do I send a query result as an email attachment?

To email the results of a query, use the @query argument. To attach those results as an attachment, use the @attach_query_result_as_file argument. This is accepts a bit value, with the default being 0 (for no attachment). To send the results in an attachment, simply provide a 1 for this argument.

How do you send a query result as a email body in SQL Server?

To send email with T-SQL, you need to use the sp_send_dbmail stored procedure in the msdb database. This procedure accepts many arguments, one of which is the @query argument. That's the argument that attaches the results of your query to the email.

How do I send SQL query output to Excel?

Steps to export query output to Excel in SQL Developer1Step 1: Run your query. To start, you'll need to run your query in SQL Developer. ... 2Step 2: Open the Export Wizard. ... 3Step 3: Select the Excel format and the location to export your file. ... 4Step 4: Export the query output to Excel.

How do you schedule a SQL query and send the result by email?

How to email SQL query results to your smartphone using the sp_send_dbmail stored procedure1Configure Database Mail in SQL Server.2Testing the mail configuration.3Test the sp_send_dbmail stored procedure.4Send queries and check query output.5Insert the current data and time in the email.6Work with HTML format in emails.

Expert · Answer