sql server - Insert/Update Triggers -

sql server - Insert/Update Triggers -

i have 2 triggers (insert , update)

create trigger my_inserttrigger after insert on `table` each row begin update previous record if found end // create trigger my_updatetrigger after update on `table` each row begin ..... end //

according understanding triggers cannot fire programmatically/manually, fires when insert/update/delete happens on table.

so question in case mentioned above, insert trigger(my_inserttrigger) invoke update trigger (my_updatetrigger)?

thanks in advance.

when changed trigger syntax sql server (with inserting 1 row) 1 trigger causes update on table kick off update trigger on table (if exists).

i have seen on audit tables , 2 things can, , will, happen:

1) performance suffer.

2) if audit triggers start kicking each other off (by having cross trggers) can run out of stack space (the triggers can nest 32 levels down).

sql-server database triggers