Geek Answers Handbook

Are there open source syntax checks for the main SQL dialects (TSQL, Oracle, MySQL)? or at least the exact specifications for these dialects?

the word on the street is that Perl is defined not by specification, but by what the current version of the interpreter accepts. Now consider SQL dialogs such as TSQL. Is there a published specification that makes the validator equivalent to what's inside SQL Server? Are such validators already open source? And the same question for Oracle.

Ok, so for MySQL, I assume that the validator can be extracted directly from the MySQL code base. However, do they really publish the specification itself in case I want to make my own validator?

+5
source share
1 answer

You seem to have an idea what to do for MySQL. I can't say much about Oracle, except that it mainly implements ANSI SQL, and PL / SQL procedural language extensions for SQL can mainly be found here for Oracle 9i.

For SQL Server:

Microsoft Books On Line (BOL) is the official reference specification. However, there are different pages for different versions of SQL Server. There are several projects related to this. http://www.sqlparser.com/ - It has versions of .NET, Java, COM and VCL for Oracle, DB2, Mysql and SQL Server / Sybase (T-SQL), very reasonable price too.

http://www.codeproject.com/Articles/1136/SharpHSQL-An-SQL-engine-written-in-C (#)

http://antlr.org/ - .

SQL, , : http://www.dpriver.com/pp/sqlformat.htm

: http://www.tsqltidy.com/

, SQL - . ISO/IEC ANSI SQL. ANSI SQL-92 , SQL: 2008. , .

.

+1

More articles:


All Articles