Re: I need MS SQL parser - please advice

Francois Gagnon <fgagnon@inouii.com>
13 May 2003 04:15:27 -0400

          From comp.compilers
Related articles
I need MS SQL parser - please advice mfjastrz@nospam.plz.cyf-kr.edu.pl (Tom Jastrzebski) (2003-05-06)
Re: I need MS SQL parser - please advice fgagnon@inouii.com (Francois Gagnon) (2003-05-13)
Re: I need MS SQL parser - please advice kurt@inobiz.com (Kurt Svensson) (2003-07-15)
| List of all articles for this month |
From: Francois Gagnon <fgagnon@inouii.com>
Newsgroups: comp.compilers
Date: 13 May 2003 04:15:27 -0400
Organization: Compilers Central
References: 03-05-024
Keywords: SQL
Posted-Date: 13 May 2003 04:15:27 EDT

We have a compiler which is a subset of SQL and we used ANTLR for this.
I would definetely recommand ANTLR over yacc... I have never used
JavaCC though...


if you are looking for a BNF grammar, it may be hard to find... but it
should not be too hard to write one using
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/htm/_lce_sql_reference_for_sql_server_ce.asp
You can probably start with a generic SQL grammar (I heard that ANTLR
has one) and "tweek" it for sql server...


fg


> Hi everybody,
>
> I urgently need MS SQL parser. First, there are some nice tools
> available. Yacc, JavaCC, ANTLR to name jest a few. Which one would
> you recommend for this purpose (I mean grammar)?
>
> Second, may be someone has already done this? I found several
> definitions for Oracle and ANSI SQL but nothing for MS SQL so far...

Post a followup to this message

Return to the comp.compilers page.
Search the comp.compilers archives again.