You prove my point perfectly. Triggers can and do work. Many legacy systems make extensive use of triggers, often with good results. However, in most new systems, the actions formerly performed by triggers are being replaced by other functionality.
As such, most DBA's will look to use one of these other methods before resorting to a trigger. > >You know a DBA who recommends and actively promotes using >>triggers? I don't. > > Well, i do. > > We use triggers with autonomous transactions to log failed attempts to > modify rows without the overhead of Oracle supplemental logging. In the > past, we have used triggers to perform "tricky" data checks, although > now we are starting to use more function based indexes and constraints > (on new projects - on the old projects the triggers are still there - > and they still work). Although i've never used them personally, Oracle > relies on INSTEAD OF triggers to implement modifiable views. No, we > don't use triggers to get the ID of the row we just inserted (we just > use the syntax "RETURNING ID INTO varname"). > > /t > > >>-----Original Message----- >>From: G [mailto:[EMAIL PROTECTED] >>Sent: Monday, April 18, 2005 4:54 PM >>To: CF-Talk >>Subject: Re: SQL Triggers (was Re: Last ID inserted) >> >>You know a DBA who recommends and actively promotes using >>triggers? I don't. >> >> >>> >Trust me. Triggers in the DB world are not looked on as >>good practive. >>> >>> The Microsoft SQL Server world is not the "DB world". >>> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203299 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
