Surprisingly few databases support true ‘Before-Insert-Triggers’ !
Least of all, both ‘row-level’ and ’statement’ level types.
Gupta SQLBase supports both ‘row-level’ and ’statement’ level types, as does Oracle.
MS SQLServer does not. (At least not without major compromises using an ‘Instead-of-Trigger’, which is a completely different thing)......
...
read more