Logical Processing of SQL

I just glanced at the logical processing flow of SQL Statements in Itziks
TSQL Querying Book and wanted to know if this applies to SQL of any RDBMS
such as Oracle, DB2,Sybase,MySQL,etc or is it strictly for SQL Server ?
Also what are the different ANSI Standards. I've heard of 92,99,2003..but
can someone refer me to what part of SQL conforms to 92,99,2003 or whatever
else is out there.
Thanks>I just glanced at the logical processing flow of SQL Statements in Itziks TSQL Querying Book and
>wanted to know if this applies to SQL of any RDBMS such as Oracle, DB2,Sybase,MySQL,etc or is it
>strictly for SQL Server ?
It is how the SQL language is constructed, so it applies to all product (that confirms at least a
little bit to the SQL language standard). Of course, stuff not in other products doesn't apply (like
TOP, GROUP BY ALL etc).
> Also what are the different ANSI Standards. I've heard of 92,99,2003..but can someone refer me to
> what part of SQL conforms to 92,99,2003 or whatever else is out there.
There is no such document out there (to the best of my knowledge). The standard is *huge*, and so is
any of the major payer's implementation. Creating such a document would be a huge work. The closest
thing I've seen was a word document for the SQL Server 2000 TSQL grammar (in BNF format) where it
syntax colored the non-ANSI parts of the language. I believe it was in the SQL Server 2000 resource
kit.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hassan" <Hassan@.hotmail.com> wrote in message news:e1yJi3RKHHA.3936@.TK2MSFTNGP02.phx.gbl...
>I just glanced at the logical processing flow of SQL Statements in Itziks TSQL Querying Book and
>wanted to know if this applies to SQL of any RDBMS such as Oracle, DB2,Sybase,MySQL,etc or is it
>strictly for SQL Server ?
> Also what are the different ANSI Standards. I've heard of 92,99,2003..but can someone refer me to
> what part of SQL conforms to 92,99,2003 or whatever else is out there.
> Thanks
>|||How can there by anything like a 'logical processing flow' if everything
happens 'all at once'?
-:)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uqsM$JTKHHA.1240@.TK2MSFTNGP03.phx.gbl...
> >I just glanced at the logical processing flow of SQL Statements in Itziks
> >TSQL Querying Book and wanted to know if this applies to SQL of any RDBMS
> >such as Oracle, DB2,Sybase,MySQL,etc or is it strictly for SQL Server ?
> It is how the SQL language is constructed, so it applies to all product
> (that confirms at least a little bit to the SQL language standard). Of
> course, stuff not in other products doesn't apply (like TOP, GROUP BY ALL
> etc).
>
>> Also what are the different ANSI Standards. I've heard of 92,99,2003..but
>> can someone refer me to what part of SQL conforms to 92,99,2003 or
>> whatever else is out there.
> There is no such document out there (to the best of my knowledge). The
> standard is *huge*, and so is any of the major payer's implementation.
> Creating such a document would be a huge work. The closest thing I've seen
> was a word document for the SQL Server 2000 TSQL grammar (in BNF format)
> where it syntax colored the non-ANSI parts of the language. I believe it
> was in the SQL Server 2000 resource kit.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:e1yJi3RKHHA.3936@.TK2MSFTNGP02.phx.gbl...
>>I just glanced at the logical processing flow of SQL Statements in Itziks
>>TSQL Querying Book and wanted to know if this applies to SQL of any RDBMS
>>such as Oracle, DB2,Sybase,MySQL,etc or is it strictly for SQL Server ?
>> Also what are the different ANSI Standards. I've heard of 92,99,2003..but
>> can someone refer me to what part of SQL conforms to 92,99,2003 or
>> whatever else is out there.
>> Thanks
>|||"Logical Processing"?
Do you mean the Query Optimizer? Or perhaps the parser?
Either way, your talking about internals and not how you use things.
However, I would assume that the base theory is going to be the same.
IMHO the Query Optimizer is written by a group of programmers that are
locked into a room and raw meat is tossed in once, or twice a day to keep
them fed.
"Hassan" wrote:
> I just glanced at the logical processing flow of SQL Statements in Itziks
> TSQL Querying Book and wanted to know if this applies to SQL of any RDBMS
> such as Oracle, DB2,Sybase,MySQL,etc or is it strictly for SQL Server ?
> Also what are the different ANSI Standards. I've heard of 92,99,2003..but
> can someone refer me to what part of SQL conforms to 92,99,2003 or whatever
> else is out there.
> Thanks
>
>