And triggers? :-) Regards,
Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -----Original Message----- From: Yager, Brian T Contractor/Sverdrup [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:44 AM To: CF-Talk Subject: RE: SP's or Triggers Are there any good books that you recommend to learn stored procedures out there? Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:45 AM To: CF-Talk Subject: RE: SP's or Triggers > Does anyone prefer Triggers over Stored Procedures to enforce business > logic? I'm trying to tell some people that SP's are better but they > wont listen. Maybe I am missing something... > > What are the advantages of a trigger over an sp? Each has advantages and disadvantages. The big advantage of triggers is that they are used no matter what - if the user or application queries tables directly, the triggers will still do their job. This is very important if there's any chance that ad-hoc SQL will be used instead of stored procedures. Personally, I prefer stored procedures because I can usually enforce access limitations to application databases such that ad-hoc or passthrough SQL can't be executed. If that's your environment, stored procedures generally provide advantages in performance and in application structure - data manipulation logic can be nicely intertwined with all database access that way. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ::::::::::::: dream :: design :: develop ::::::::::::: MXDC 02 :: Join us at this all day conference for designers & developers to learn tips, tricks, best practices and more for the entire Macromedia MX suite. September 28, 2002 :: http://www.mxdc02.com/ (Register today, seats are limited!) :::::::::::::::::::::::::::::::::::::::::::::::::::::: ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
