Re: a simple sql question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Tony and Erland,

I can confirm Erland. I wrote a course for 6.5 (news) and distinctively remember that ANSI joins were new (along with ROLLUP and CUBE). I also recall some nasty bugs in 6.5 RTM with new-style joins. It took me to version 7 until I was feeling comfortable using new-style joins.

And just to be certain, I fire up a VM with 6.5 and check BOL. They didn't re-write BOL for 6.5, they just added a "What's new in SQL Server 6.5" section (without integrating those bits into the main topics).

Here's a quote from the TSQL, joins section:

"
ANSI-standard join clauses are supported and include:
· JOIN
· CROSS JOIN
· INNER JOIN
· LEFT OUTER JOIN
· RIGHT OUTER JOIN
· FULL OUTER JOIN

Earlier versions of SQL Server joins continue to be supported although they will be discontinued in a future release.
"

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Tony Rogerson" <tonyrogerson@xxxxxxxxxx> wrote in message news:044287D1-61E1-4EFF-ACCC-E13650F374B8@xxxxxxxxxxxxxxxx
Are you sure about that Erland?

Back in the mid nineties I worked at Centre-file developing a workflow product - I worked on the database which was 6.0 and I'm sure we used ansi-92; it wasn't long before 6.5 launched - 6.0 was a big move away from 4.21 which is what we where using on another project that had just gone live (replacement of the credit card stuff for Natwest).

Tony.

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message news:Xns9C2C652A9AC4Yazorman@xxxxxxxxxxxx
Tony Rogerson (tonyrogerson@xxxxxxxxxx) writes:
Certainly for Oracle they got it a few versions after SQL Server - the
ansi 92 syntax was introduced in SQL 6.0 which was somewhere around
94-95 I think (I'd need to check my resume).

The ANSI syntax was added in SQL 6.5, not 6.0.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.

Relevant Pages

  • Re: a simple sql question
    ... I can confirm Erland. ... remember that ANSI joins were new. ... · CROSS JOIN ... Earlier versions of SQL Server joins continue to be supported although ...
    (microsoft.public.sqlserver.programming)
  • Re: lizenzfrage zum sql server 2008 express
    ... im lizenzdialog der sql server 2008 express edition ist meiner firma ... Unless applicable law gives you more rights despite this limitation, ... · disclose the results of any benchmark tests of the software to any third ...
    (microsoft.public.de.sqlserver)
  • Re: getdate() in UDF
    ... Or it is classified as imprecise rather than non-deterministic? ... return from Erland) ... > Here noofyears is a computed column which tells us how long a person ... > SQL Server must materialize the values. ...
    (microsoft.public.sqlserver.programming)
  • Re: more than 8192 characters in text file output
    ... Thanks Erland. ... results that are "export as grid" you can't choose the delimiter. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • Re: stored procedure question
    ... Erland, ... regarding computing and large insert be done directly in the database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)