MSDN上不是有很多例子的吗?使用包含提醒电子邮件的 DML 触发器 USE AdventureWorks; GO IF OBJECT_ID ('Sales.reminder2','TR') IS NOT NULL DROP TRIGGER Sales.reminder2; GO CREATE TRIGGER reminder2 ON Sales.Customer AFTER INSERT, UPDATE, DELETE AS EXEC msdb.dbo.sp_send_dbmail @profile_name = 'AdventureWorks Administrator', @recipients = '[email protected]', @body = 'Don''t forget to print a report for the sales force.', @subject = 'Reminder'; GO
CREATE TRIGGER 触发器名 ON 表名 for INSERT|UPDATE|DELETE AS 操作 GO
USE AdventureWorks;
GO
IF OBJECT_ID ('Sales.reminder2','TR') IS NOT NULL
DROP TRIGGER Sales.reminder2;
GO
CREATE TRIGGER reminder2
ON Sales.Customer
AFTER INSERT, UPDATE, DELETE
AS
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'AdventureWorks Administrator',
@recipients = '[email protected]',
@body = 'Don''t forget to print a report for the sales force.',
@subject = 'Reminder';
GO
ON 表名
for INSERT|UPDATE|DELETE
AS
操作
GO