The below is a list of all of the articles that have been written on this blog.
Sending Email Through SQL Server (Part-1)
This topic describes how to use DBMail in various scenarios. To avail the functionality, database mail must be configured in your environment.1) Send a test email from SQL Server using DBMail.2) Send a test email to multiple recipients in “TO” section.3) Send a test email to different recipients in different fields (To, CC and BCC)4)…
Sending Email Through SQL Server (Part-2)
If you’re an aspiring learner and you haven’t been through the previous part, please click here. If you are already aware of the basic implementation, read on.8) Send a mail in a simple text format based on a query with clauses.USE msdbGODECLARE@iDeptID INT,@SQL NVARCHAR(MAX),@Tab char(1)=char(9)SELECT @iDeptID = MAX(DeptNo) FROM TestDB.dbo.Dept WITH (NOLOCK)SELECT @SQL =’ SELECT…
Sending Email Through SQL Server (Part-3)
Please click here for the Part-1.Please click here for the Part-2.11) Send the query results in a Stylish HTML & CSS formatCode Credits : https://www.sqlshack.com/format-dbmail-with-html-and-css/Please click here for the code.This will return the following output in the email.
One comment