Appendix A: SQL Grammar Reference

In This Toolbox

Log Parser works on queries written using a dialect of the Structured Query Language (SQL). Even though the Log Parser SQL dialect draws much from the standard ANSI SQL language, there are some differences whose understanding will help users make the most out of the Log Parser tool.

Complete Syntax

 ->  [ ] [  ]            [  ] [  ]           [  ] [  ] -> SELECT [ TOP  ] [ DISTINCT  ALL ]                        ->  [ ,  ]       ->  [ AS  ]                               *            -> USING              -> INTO              -> FROM             -> WHERE               ->  [ OR  ]                    ->  [ AND  ]