Who controls SQL language?

Question

Who controls SQL language?

Crispin Proctor

SSCoach

Points: 18161
More actions
June 24, 2003 at 7:12 am

#82393

I was having an argument with a co-worker. He said that the W3C controlled SQL.
As far as I can see on their site, the don't. I know Microsoft has got their own standard but who used(?) to controll it or was it an open standard?
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Hi Crispin,

quote:
I was having an argument with a co-worker. He said that the W3C controlled SQL.
As far as I can see on their site, the don't. I know Microsoft has got their own standard but who used(?) to controll it or was it an open standard?

I guess http://www.ANSI.org

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Crispin Proctor SSCoach Points: 18161 More actions · Answer 2

ahhh, Frank.

Should have guessed you'de be here. You seem to do less work than me. If that's possible?

Cheers,

Crispin

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

quote:
ahhh, Frank.
Should have guessed you'de be here. You seem to do less work than me. If that's possible?

that seems to be hard work

Cheers,

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

kbe SSC Rookie Points: 41 More actions · Answer 4

The American National Standards Institute (ANSI) published its first SQL standard in 1986. The latest update was in 1999, giving us SQL99, which is what most vendor implementations try to be compatible with. Remember, this is just a standard; there are still differences between different vendor products and specific commands that may or may not be cross-compatible.

Mark Twain Newbie Points: 7 More actions · Answer 5

The SQL standard is referred to as

ISO/ANSI SQL Standard; these two organizations control it. Most software vendors (including IBM, Oracle and Microsoft) have "extended" the standard, though Most SQL dialects are trying hard to be SQL2 (SQL92) compliant; some claim SQL99 (SQL3) compliance.

In short: there is a standard controlled by ISO/ANSI, there are SQL dialect who have some level of compliuance with trhe standard; their "non-compliant" part is controlled by the vendor.