Trigger:
Let's say
you want to send an email to the Sales Manager when an order is entered whose
priority is high. When ad hoc SQL is used to insert the Orders row, a trigger
is used to determine the OrderPriority and send the email when the criteria is
met.
Example:
CREATE
TABLE Orders (Ord_ID int IDENTITY, Ord_Priority varchar(10))
go
CREATE TRIGGER tr_Orders_INSERT
ON Orders
FOR INSERT
AS
IF (SELECT COUNT(*) FROM inserted WHERE Ord_Priority = 'High') = 1
BEGIN
PRINT 'Email Code Goes Here'
END
go
INSERT Orders (Ord_Priority) VALUES ('High')
-- Results --
Email Code Goes Here
go
CREATE TRIGGER tr_Orders_INSERT
ON Orders
FOR INSERT
AS
IF (SELECT COUNT(*) FROM inserted WHERE Ord_Priority = 'High') = 1
BEGIN
PRINT 'Email Code Goes Here'
END
go
INSERT Orders (Ord_Priority) VALUES ('High')
-- Results --
Email Code Goes Here
