sql server - Send Data Via Email in T-SQL -


i writing stored procedure collects changes happend in table given date , send recordset administrator via email sql batch job.

now untill now, couldn't figure out how send recordset in email body. possible construct email body based on recordset obtained tsql logic.

any appriciated

thanks

theitguy

look sp_send_dbmail procedure, allows execute query , send results in e-mail body or file attachment.


Comments

Popular posts from this blog

c++ - How to modify context menu of internet explorer using IDocHostUIHandler::ShowContextMenu? -

android - Spacing between the stars of a rating bar? -

c# - Getting "Internal .Net Framework Data Provider error 30" error when column has NULL value -