General SQL Parser .NET version 1.6.5

Description

General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also provides more detail information about a SQL statement such as statement types (Select, insert, update, delete or create and so on), what's table and fields are used in a statement, and different parts of a SQL statement are also available such as where clause, group by clause and having clause and so on...

General SQL Parser is designed to deal with SQL statement used by different Database Such as Oracle,DB2,Informix,Sybase,Postgres,MySQL and so on. And we will make it conforms to most of the entry-level SQL99 Standard.

Features overview


.NET, COM and VCL version, so it can be used in various development environment such as C#, VB .NET, VC++, VB, DELPHI, Free Pascal, Kylix
Create parser for different databases such as MSSQL,Oracle to deal with different sql dialects.
Syntax check, give the error token, position and hint message.
Pretty print SQL statements with lots of configurable parameters, make it more readable.
Modify all parts of input sql, then rebuild on the fly.
Identify various database objects such as table, field, function in sqls.
Create different visitors to visit parse tree for any purpose with the full control of all tree nodes.
Export parse tree to xml string for further processing.
Generate a list of TCustomSqlStatement objects which represent the corresponding SQL statements that have been parsed.
Parser can be instructed to ignore syntax error and continue.
Continuously check multiple SQL Statements even if there are syntax errors in some of these statements.

1. EMS Data Export 2005 for SQL Server 2
   EMS Data Export for SQL Server is a powerful program to export your data quickly from Microsoft SQL and MSDE databases to any of 15 available formats,.
2. EMS Data Import 2005 for MySQL 2
   EMS Data Import for MySQL is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, XML, TXT and CSV files to MySQL tables.
3. EMS Data Import 2005 for PostgreSQL 2
   EMS Data Import for PostgreSQL is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, XML, TXT and CSV files to PostgreSQL tab.
4. EMS Data Import 2005 for SQL Server 2
   EMS Data Import for SQL Server is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, XML, TXT and CSV files to Microsoft SQL S.
5. EMS SQL Manager 2005 Lite for MySQL 3
   EMS SQL Manager Lite for MySQL is an excellent freeware graphical tool for MySQL Server administration.
6. Backup Watcher for MySQL 1.9
   Program Backup Watcher for MySQL is intended for making database backups of the MySQL server.
7. EMS SQL Manager 2005 Lite for SQL Server 2
   EMS SQL Manager Lite for SQL Server is a light and easy-to-use freeware graphical tool for MS SQL/MSDE administration.
8. EMS SQL Manager 2005 Lite for PostgreSQL 3
   EMS SQL Manager Lite for PostgreSQL is a light and easy-to-use freeware graphical tool for PostgreSQL administration.
9. DecryptSQL 2.8
   Do you often have a headache when you try to get the decryption MS SQL stored procedure, Trigger, Function, View.
10. SQL Examiner Bundle 1
    SQL Examiner bundle meets all your SQL database comparison and synchronization needs.