send mail via SQL SERVER

How to send E-mail/E-mail with Attachments in SQL Server TIP #97

  In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail in SQL SERVER. Sometimes we need to send mail for different requirements like 1) Notification mails like  data inserted /updated/deleted successfully 2)Send data reports like no of amount earned, failed transaction  etc. for this …