Tutorial by Examples | RIP Tutorial

Send simple email

This code sends a simple text-only email to [email protected] EXEC msdb.dbo.sp_send_dbmail @profile_name = 'The Profile Name', @recipients = '[email protected]', @body = 'This is a simple email sent from SQL Server.', @subject = 'Simple email'

Microsoft SQL Server • DBMAIL

Send results of a query

This attaches the results of the query SELECT * FROM Users and sends it to [email protected] EXEC msdb.dbo.sp_send_dbmail @profile_name = 'The Profile Name', @recipients = '[email protected]', @query = 'SELECT * FROM Users', @subject = 'List of users', ...

Microsoft SQL Server • DBMAIL

Send HTML email

HTML content must be passed to sp_send_dbmail SQL Server 2012 DECLARE @html VARCHAR(MAX); SET @html = CONCAT ( '<html><body>', '<h1>Some Header Text</h1>', '<p>Some paragraph text</p>', '</body></html>' ) SQL Server 2012 ...

Microsoft SQL Server • DBMAIL