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
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 msdbGO DECLARE@iDeptID INT,@SQL NVARCHAR(MAX),@Tab char(1)=char(9) SELECT @iDeptID = MAX(DeptNo) FROM TestDB.dbo.Dept WITH (NOLOCK)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.
Big Data and SQL 
One comment