They are essentially the same for more of your everyday queries. There are a couple of minor differences (like the TOP keyword), but mostly they are the same syntax-wise. When you get into more advanced stuff (like triggers) they do differ.
Also worth noting - CF Standard supports MS SQL out of the box. For Oracle drivers you have to either pay for CF Enterprise or download and install your own JDBC drivers. -Cameron On Fri, May 2, 2008 at 10:19 PM, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > What is the difference between CF + MSSQL and CF + Oracle? > > Is the query structure for Oracle that much different? > > -- Cameron Childress Sumo Consulting Inc http://www.sumoc.com ---cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:259732 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
