In the main I don't think it matters all that much, but here are some issues to consider:
1
I would add that
you usually will not be able to use the rich set of trigger features in SQL Anywhere - possibly no BEFORE triggers, no ROW LEVEL triggers (with their much easier semantics IMHO) - at least I always feel "in limited mode" when I have to deal with MS SQL triggers...
(19 Dec '11, 03:31)
Volker Barth
|
I have no "best practise" answer - it may also depend on whether you are used to write a single trigger for multiple actions (e.g. a combined insert/update trigger)...