Differences between TSQL and SQL-92

Hi,
I guess there should be some differences between SQL Server's dialect
TSQL and strictily the SQL-92 standard.
For a researcg work I'm doing I need to collect and study this
difference, I've not found big things so far more than a few difference
in functions, unless my BNF lecture is failing.
Does anybody know an existing article that already put TSQL and SQL-92
face to face ?
Is there any big noticeable difference that you can cite here in this
newsgroup ?
Thanks in advance,Bunch of things. Which level of ANSI SQL -92? SQL Server supports the entry
level, but it also has a
load of stuff outside ANSI SQL 92. In SQL Server resource kit, there's a big
word doc which points
out whether each TSQL command adheres to ANSI SQL-92. Also, you can try the
SQL validator at
www.mimer.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
<craigkenisston@.hotmail.com> wrote in message
news:1109363354.285681.136860@.f14g2000cwb.googlegroups.com...
> Hi,
> I guess there should be some differences between SQL Server's dialect
> TSQL and strictily the SQL-92 standard.
> For a researcg work I'm doing I need to collect and study this
> difference, I've not found big things so far more than a few difference
> in functions, unless my BNF lecture is failing.
> Does anybody know an existing article that already put TSQL and SQL-92
> face to face ?
> Is there any big noticeable difference that you can cite here in this
> newsgroup ?
>
> Thanks in advance,
>|||Why are you concerned with a standard that's obsolete:)|||>> Why are you concerned with a standard that's obsolete:) <<
Because the US Government says that SQL-99 and beyond are "Standards in
progress" and they want to see SQL-92 conformance? Because Microsoft
and the other big guys are *still* trying to come up to it?
Much of SQL-99 and SQL:2003 are like Algol-68, ADA and PL/I. Possible
to implement at great expense, but impossible for the average guy to
program with and doomed to produce horrible bulky code even for simple
tasks.|||--CELKO-- wrote:
>
> Because the US Government says that SQL-99 and beyond are "Standards in
> progress" and they want to see SQL-92 conformance? Because Microsoft
> and the other big guys are *still* trying to come up to it?
> Much of SQL-99 and SQL:2003 are like Algol-68, ADA and PL/I. Possible
> to implement at great expense, but impossible for the average guy to
> program with and doomed to produce horrible bulky code even for simple
> tasks.
>
--BEGIN PGP SIGNED MESSAGE--
Hash: SHA1
What about Ocelot DB? They claim to be compliant w/ SQL-99 and the
software is Open-Source (inexpensive?).
http://www.ocelot.ca/
"This is an uncrippled SQL:1999 database management system, an official
implementation of ISO standard SQL and ANSI standard SQL."
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
--BEGIN PGP SIGNATURE--
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/ AwUBQiKkPIechKqOuFEgEQI5kQCfSGyubHDnApwA
bmeOvPkGhEWOhwAAoOT7
nMt9jFhsUm7mAXhgEPORninN
=Gx9I
--END PGP SIGNATURE--|||MGFoster wrote:
> --CELKO-- wrote:
>
> --BEGIN PGP SIGNED MESSAGE--
> Hash: SHA1
> What about Ocelot DB? They claim to be compliant w/ SQL-99 and the
> software is Open-Source (inexpensive?).
> http://www.ocelot.ca/
> "This is an uncrippled SQL:1999 database management system, an official
> implementation of ISO standard SQL and ANSI standard SQL."
>
--BEGIN PGP SIGNED MESSAGE--
Hash: SHA1
On second reading of the ocelot site I believe I've been mislead by the
"SQL:1999" designation instead of "SQL-99." Ocelot's designation seems
to indicate that the product was finished in 1999, not that it is fully
SQL-99 compliant RDBMS.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
--BEGIN PGP SIGNATURE--
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/ AwUBQiOe6IechKqOuFEgEQIl2gCfRdhJqAcXXSZb
N6RDhOg9tr7J78gAoIxr
oeMayceW7oem+/h1xBCm3lma
=UxGQ
--END PGP SIGNATURE--|||Are you Joe Celko ?
Well, I guess no other can reply with such authority :)
I recently ordered a couple of your books.
I wonder if you can make some recommendation on the following:
Im in a team working on the implementation of a query processor for a
propietary data format.
We need information specifically about the query processor
implementation in a database management system.
Besides the thousands articles in ACM and VLDB, which take very
specific topics, we have found just two books that cover this :
- Database Management Systems by Raghu Ramakrishnan
- Database Systems: The Complete Book by Garcia-Molina
Could you recommend other books on this topic ?
Thanks in advance !