Is SQL Server SQL99 Compliant

[seapearl1023]

Hi,

My question is if MS SQL Server 2000 Standard version is SQL99
Compliant? How about MS SQL Server 2000 Enterprise version, MS SQL
Server 6.5/7.0?

Thanks.

Hai-Chu

[Erland Sommarskog]

(se**********@ms65.url.com.tw) writes:

My question is if MS SQL Server 2000 Standard version is SQL99
Compliant? How about MS SQL Server 2000 Enterprise version, MS SQL
Server 6.5/7.0?

I don't think SQL 2000 complies even to the entry-level of SQL99.
SQL7 and SQL 6.5 that predate SQL-99 (I assume, since they came out
before 1999!), even less do so.

There is no difference between Enterprise and Standard Edition, since
the differences between different editions are not in language features.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Gary]

SQL Server 2000 does not conform to the ANSI SQL:1999 standard. From
what I understand, it also does not conform completely to the ANSI
standard previous to that, ANSI SQL-92.

[DA Morgan]

Gary wrote:

SQL Server 2000 does not conform to the ANSI SQL:1999 standard. From
what I understand, it also does not conform completely to the ANSI
standard previous to that, ANSI SQL-92.

SQL Server 2000 does not conform and neither does anyone else's product
if you mean full compliance. All the talk about compliance is
meaningless because the marketplace just doesn't care.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

[Serge Rielau]

se**********@ms65.url.com.tw wrote:

Hi,

My question is if MS SQL Server 2000 Standard version is SQL99
Compliant? How about MS SQL Server 2000 Enterprise version, MS SQL
Server 6.5/7.0?

Thanks.

Hai-Chu

Unlike SQL-92 there is no test certifying compliance of any product to
SQL-99 or later.
So the best you will get from any DBMS vendor is an unverifiable opinion.

Cheers
Serge

[Erland Sommarskog]

DA Morgan (da******@x.washington.edu) writes:

Gary wrote:

SQL Server 2000 does not conform to the ANSI SQL:1999 standard. From
what I understand, it also does not conform completely to the ANSI
standard previous to that, ANSI SQL-92.
SQL Server 2000 does not conform and neither does anyone else's product
if you mean full compliance.

I believe that SQL 2000 conforms to the entry-level of ANSI-92, but I
could be wrong, because as you say:
All the talk about compliance is meaningless because the marketplace
just doesn't care.

I wholeheartedly agree.

Even if the same syntax would run on, say, SQL Server and Oracle, the code
may still prove not to port straight away between the two engines, because
of performance issues.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp