By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Is SQL Server SQL99 Compliant

P: n/a
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

Jul 23 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
(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
Jul 23 '05 #2

P: n/a
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.

Jul 23 '05 #3

P: n/a
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 =---
Jul 23 '05 #4

P: n/a
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
Jul 23 '05 #5

P: n/a
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
Jul 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.