Is SQL Server SQL99 Compliant

[seapearl1023@ms65.url.com.tw]

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]

Re: Is SQL Server SQL99 Compliant

(seapearl1023@m s65.url.com.tw) writes:[color=blue]
> 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?[/color]

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, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Gary]

Re: Is SQL Server SQL99 Compliant

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]

Re: Is SQL Server SQL99 Compliant

Gary wrote:
[color=blue]
> 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.[/color]

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
damorgan@x.wash ington.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]

Re: Is SQL Server SQL99 Compliant

seapearl1023@ms 65.url.com.tw wrote:[color=blue]
> 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
>[/color]
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]

Re: Is SQL Server SQL99 Compliant

DA Morgan (damorgan@x.was hington.edu) writes:[color=blue]
> Gary wrote:[color=green]
>> 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.[/color]
>
> SQL Server 2000 does not conform and neither does anyone else's product
> if you mean full compliance.[/color]

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

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, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp