上一篇文章讲解到配置数据库邮件实现发送邮件功能。
邮件的内容为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 added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @tableHTML NVARCHAR(MAX) ;
if exists(
SELECT td = RTRIM(TC001), '',
td = RTRIM(TC002), '',
td = RTRIM(TD003), '',
td = RTRIM(TC004), '',
td = RTRIM(MA003), '',