> Can someone explain, in general if possible when the best time to use
> SQL Server views/storedProdedures/triggers VS. CF Queries?
Use Stored Procedures wherever you can. They're usually quicker than
plain CF queries, sometimes enormously so, and help to modularise your
code, which is always good.
Triggers don't do much for you that SP's can't, but they're simpler.
Personally I'm not a big user of views.
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
