Please enable JavaScript.
Coggle requires JavaScript to display documents.
13.2 Triggers (Types (DDL trigger
e.g. create table, DML trigger
…
13.2 Triggers
-
-
-
-
-
create trigger dbo.TR_...
on dbo.cat
instead of insert
(after insert, delete, update)
as begin
if ... begin ... end
else
insert....select ....
end
DML trigger functions
columns_update() :!?:
update(qty)
check if qty column
is updated
vb. if update(qty)
print 'qty updated'