On Mon, Dec 29, 2008 at 4:30 PM, BobSharp wrote: > Has anyone heard of "SQL-92" ?
SQL-92 refers to the 1992 version of the SQL standard. At that time it was maintained by ANSI, so it is also on occasion referred to as ANSI-SQL. The current maintainer of the SQL standard is the IEC, a committee of ISO, and they have released ISO IEC 9075:2008 last August. The core syntax for simple SELECT / INSERT / UPDATE / DELETE statements hasn't changed significantly since the 1992 version, but the syntax for stored procedures, recursive queries, OLAP, etc. is completely different (or more precisely, absent in the 92 version). Most databases currently implement most of the syntax from SQL-92, and a significant subset of the syntax from SQL-99. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
