Re: SQL standard

Even if you write for the lowest common denominator, the SQL that is, different databases handle things differently. (e.g. locking, concurrency etc.) When you write c or c++ code (or pick a computer language) do you only write to a particular standard and never take advantage of a particular vendor or compilers feature? If not then why buy the compiler database in the first place? When you drive a motor vehical do you drive it like the lowest common denominator of motor vehicals? (be it a car, truck, bus, motorcycle)

Yes, there is a standard, but it is really more complex in that there are levels of the standard with regards to different parts. (and of course what version of the standard.)

Jim

"Chariya Peterson" <Chariya.Peterson_at_noaa.gov> wrote in message news:3BE96D18.7A0D1819_at_noaa.gov...
>
> Sorry if you saw this posting somewhere else. I am cross posting this
> message in other comp.databases groups.
>
> Could someone please post some URLS and/or FAQ with information on SQL
> standard. I'd like ot find out how truely
> this standard is in terms of vendors independence. And whether a
> software could be developed in such a way that it is portable to any
> RDBMS, perhaps with some restrictions on the query statements to ward
> off any extension beyond the standard.
>
> Thanks,
> chariya
>
>
>
Received on Thu Nov 08 2001 - 03:29:58 CET