>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:203282 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
