Trigger INSTEAD OF (DML)

Membangun dan Mengoptimalkan Trigger di SQL Server

Florin Angelescu

Instructor

Definisi dan properti

Menjalankan serangkaian aksi saat dipicu
Aksi dijalankan menggantikan event DML
Event DML tidak dijalankan lagi
Dipakai dengan pernyataan INSERT, UPDATE, dan DELETE untuk tabel atau view

Prasyarat trigger INSTEAD OF

| ID  | Customer        | Product   | Price | Quantity | OrderDate  | TotalAmount |
|-----|-----------------|-----------|-------|----------|------------|-------------|
| 284 | VitaFruit       | Orange    | 0.76  | 75       | 2018-09-17 | 57.00       |
| 330 | Healthy Choices | Raspberry | 1.96  | 200      | 2018-10-29 | 392.00      |
| 302 | World of Fruits | Pineapple | 4.16  | 25       | 2018-10-09 | 104.00      |
| 248 | Fruit Mania     | Plum      | 1.11  | 300      | 2018-08-11 | 333.00      |
| 358 | Fruit Mag       | Pomelo    | 1.11  | 750      | 2018-11-29 | 832.50      |
| 100 | VitaFruit       | Avocado   | 2.91  | 500      | 2018-03-29 | 1455.00     |

Prasyarat trigger INSTEAD OF

Tabel target
Deskripsi trigger
Event pemicu (DML)
Nama trigger

Orders
Cegah pembaruan entri yang ada
UPDATE
PreventOrdersUpdate

Definisi trigger INSTEAD OF

CREATE TRIGGER PreventOrdersUpdate

ON Orders

INSTEAD OF UPDATE

AS
    RAISERROR ('Updates on "Orders" table are not permitted.
                Place a new order to add new products', 16, 1);

Ayo berlatih!

Membangun dan Mengoptimalkan Trigger di SQL Server