The below is a list of all of the articles that have been written on this blog.
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
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
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.