I-Lin Kuo is a developer at the Inter-University consortium for Social and Political Research at the University of Michigan, Ann Arbor. He is also a coordinator of the Ann Arbor Java Users Group as well as a frequent contributor to the CFDJ List mail list.
Have you ever written an application using one database only to have it break
when you switched to a different database? How often have you decided to
limit the functionality of your database by writing only basic SQL because
you just weren't sure if your queries would work on a different database?
Or maybe you've written ColdFusion code to manipulate query results without
realizing that the database could do the same manipulation quicker and more
efficiently. In general, the database tends to be seriously underutilized in
most applications. This article aims to provide a quick overview of some
important SQL differences between the two most popular commercial databases -
Oracle9i and SQL Server 2000 - to help the CF developer write more portable
and database-smart applic... (more)
I-Lin Kuo is a developer at the Inter-University consortium for Social and Political Research at the University of Michigan, Ann Arbor. He is also a coordinator of the Ann Arbor Java Users Group as well as a frequent contributor to the CFDJ List mail list.
Bob Snyder
Jacques Durand
Alf Pilgrim
Per Sjofors
Kirsten Lytsen
Data Recovery Services
Colin Armitage
