4>
5>
6> CREATE TABLE discounts(
7> discounttype varchar(40) NOT NULL,
8> stor_id char(4) NULL ,
9> lowqty smallint NULL,
10> highqty smallint NULL,
11> discount dec(4,2) NOT NULL
12> )
13> GO
1>
2> insert discounts values("Initial Customer", NULL, NULL, NULL, 10.5)
3> insert discounts values("Volume Discount", NULL, 100, 1000, 6.7)
4> insert discounts values("Customer Discount", "8042", NULL, NULL, 5.0)
5> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
2> CREATE TRIGGER trDiscounts_InsDel ON discounts
3> FOR INSERT, DELETE
4> AS
5> DECLARE @intRowCount INTEGER,
6> @chvMsg VARCHAR(255)
7> SELECT @intRowCount = @@RowCount
8> SELECT @chvMsg = CONVERT(VARCHAR(10), @intRowCount ) + " record(s) were "
9> SELECT COUNT(*) FROM inserted
10> IF @@error <> 0
11> SELECT @chvMsg = @chvMsg + " deleted from the discounts table."
12> ELSE
13> SELECT @chvMsg = @chvMsg + " inserted into the discounts table."
14> EXEC master..xp_sendmail "Colleen", @chvMsg
15> RETURN
16> GO
1>
2> drop trigger trDiscounts_InsDel;
3> GO
1>
2>
3> drop table discounts;
4> GO