Лекція 8. Збережені процедури та тригери

17. Приклад тригера

USE pubs

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'reminder' AND type = 'TR') DROP TRIGGER reminder

GO

CREATE TRIGGER reminderON titlesFOR INSERT, UPDATE, DELETE

AS EXEC master..xp_sendmail 'MaryM', 'Don''t forget to print a report for the distributors.‘

GO