General SQL Parser provides detail information about a SQL statement such as statement types (Select, insert, update, delete or create and so on), what's tables 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...

Due to the complexity of the SQL grammar, many people have attempted but failed to generate a successful parser. Here, at Gudu Software, we have developed a parser that can successfully reduce the difficulties associated with decoding SQL grammar. Vendors are constantly releasing new versions of databases, so maintaining an original home-grown SQL parser is time consuming, error-prone, and costly. We are dedicated to helping your product adapt to the latest versions of database programs. With the appropriate library, like the one we provide, you can save hundred of hours, if not more, on developing time. As a result, the efficiency of your business will increase dramatically.

FEATURES:

Clean up messy SQL codes:
· Easily integrate SQL formatter into your application for a color coded layout that is easy to navigate, giving your product a professional feeling.

Detect SQL syntax errors:
· Your application will be able to validate SQL syntax before a database executes the query. This is very useful especially if your SQL was dynamically built based on user input.

Rid SQL injections:
· Avoid being vulnerable to SQL injection in your ASP.NET or Java application, by automatically detecting malicious SQL segment with our ready-to-use library.

Retrieve/Refactor table & column name:
· Precisely determining and renaming every table and column in stored SQL statements is very complex with a lot of nesting and sub-queries, but we can make it hassle-free for you.

Find affected SQL objects:
· Parse out the affect SQL objects in a SQL file that can have many different types of SQL (select, insert, create, drop, etc), and helping to determine what is being affected, including but not limited to schema, table, column.

Discover the relationship in DDL:
· Quickly locate the primary key and/or foreign key in DDL scripts to figure out the complex relationship among the various tables. Extracted table, attribute names, data types can be used to generate the CRUD-Statements.

Query parse tree in XML:
· Parsing SQL is a notoriously difficult task, but we are here to help. You will be provided with a SQL query parse tree in XML output that will allow you to further process SQL scripts.

Rewrite and convert SQL:
· Modify SQL expression/condition in where clause to reconstruct a new filter. Rewrite Oracle proprietary joins to ANSI SQL compliant joins. Translate SQL between different databases.

CRUD Reportor:
· Read complex and large SQL scripts to find out tables have Create, Read, Update, Delete and Insert operations against them immediately, it's almost impossible to do that without help with a tool.

SQL Parser can even do more:
· We are dedicated to constantly improving our product so it will be easier to use with more flexibility, making it a valuable asset to your software product. Here, we have provided you with additional demos that may be helpful to you.

New Release
· support - character in DB2 identifier
· support parenthesis in the left side of set clause of DB2.
· rename unit dbcmds to lzdbcmds.
· support sql server deny statement
· support sql statement that block statement that follow declare statement directly.
· support FETCH FIRST ROW ONLY
· fixed a bug which will slow down the parse( and even freeze the parse) when the table name is a big query
· add %prec OUTER_JOIN to rule joined_table, so all of those table_ref XXX RW_JOIN table_ref have the same priority, this make following sql organized correctly: SELECT *, FROM S1, natural join w3, LEFT OUTER JOIN S2, ON S1.S = S2.S

New format options:
· gfmtopt.declare_list_style,
· gfmtopt.declare_comma_option,
· gfmtopt.LinebreakBeforeParamInExec replaced by
· gfmtopt.exec_first_paramater_in_newline
· gfmtopt.exec_parameters_style
· gfmtopt.exec_parameters_comma_option
· gfmtopt.exec_parameters_align_value
[ General SQL Parser .NET release history ]

Hyperlink code:
Hyperlink and Intro code:
Hyperlink for Forum code:

All General SQL Parser .NET reviews, submitted ratings and written comments become the sole property of Windows 7 download. You acknowledge that you, not windows7download, are responsible for the contents of your submission. However, windows7download reserves the right to remove or refuse to post any submission for any reason.

Windows 7 Download periodically updates pricing and software information of General SQL Parser .NET full version from the publisher, but some information may be out-of-date. You should confirm all information.
Using warez version, crack, warez passwords, patches, serial numbers, registration codes, key generator, pirate key, keymaker or keygen for General SQL Parser .NET license key is illegal and prevent future development of General SQL Parser .NET. Download links are directly from our mirrors or publisher's website, General SQL Parser .NET torrent or shared files from free file sharing and free upload services, including Rapidshare, MegaUpload, YouSendIt, SendSpace, DepositFiles, DivShare, HellShare, HotFile, FileServe or MediaFire, are not used.