Walter,
There are several, as I remember it 4, levels of compliance with the ANSI
SQL Standard. If I remember it right they range from Entry Level (minimum
compliance) to Fully Compliant With Extensions with a couple in between. I
believe, someone can correct me if I'm wrong, MicroSoft SQL*Server is only Entry
Level compliant while DB2/Informix and Oracle are Fully Compliant With
Extensions. I believe Sybase is Level 3 compliant meaning they have no
extensions. Level 2 I believe is fully compliant without a procedural
interface.
Dick Goulet
____________________Reply Separator____________________
Author: Walter K <[EMAIL PROTECTED]>
Date: 5/3/2001 8:41 AM
Which RDBMS is more ANSI SQL compliant, Oracle or MS
SQL Server?
I have some frustrated SQL Server developers that only
understand how to write inner and outer joins using
SQL Server's syntax. Don't DB2, Informix and Sybase
use the same method of defining joins as predicates?
Just curious. Maybe I'm crazy.
-w
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
