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
>
>

Logging the control flow hierarchy

Hello,

I am using the event handling mechanism to do my custom logging. This works fine. Using the OnPreExecute and OnPostExecute my log tables fill up with the start- and enddates of all the containers and tasks in the complete package hierarchy.

However, what I am missing (e.g. in a system variable) is the source ID of the parent container that started the task or container. In other words, in my logging reports, I would like to build up a tree starting with the topmost package, like the progress indication in the IDE.

The built-in Logging features do not log this information either as far as I can tell.

Does anyone know how to do this?

Kind regards,
Jeroen

Watch the Kimball Webcast listed on the first page of this forum. Joy Mundy talks about auditing and she shares with us quite a bit about it and how she did it. One of the things she does is to log the parent package's information and then each child it executes logs its own information along with the parent ID so that everything is tied together.|||

Hi Jeroen,

If you enable logging in parent container this will be done automatically in log file created by SSIS. If you are looking for custom logs then you can use Dts.Log() method to write custom logs. I believe you will have to write your own logic using ScriptTask to build a tree structure for logs.

Thanks

Mohit

|||

MohitGupta wrote:

If you are looking for custom logs then you can use Dts.Log() method to write custom logs.

More information on how to create a custom log provider can be found here: http://msdn2.microsoft.com/en-us/library/ms136010.aspx