上一篇文章讲解到配置数据库邮件实现发送邮件功能。
邮件的内容为HTML格式。
案例:
-- =============================================
-- Author: <Author,David Gong>
-- Create date: <Create Date,2017-08-20,>
-- Description: <Description,新增采购单无ROHS报告预警,>
-- =============================================
ALTER TRIGGER [dbo].[TR_NOROHS]
ON [dbo].[PURTD]
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON adde