Skip to content
No results
We use cookies to ensure that we give you the best experience on our website.

# Separate the SQL Commands in a SQL script

Sometimes you just want to get separate SQL statement from a big SQL script, this is not that easy in a SQL Server script, because there is no delimiter operator such as ; required to separate SQL statements in SQL Server script like Oracle or other databases do.

General SQL Parser can help you to achieve this quickly.

Code in Java:

        TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvmssql);
        sqlparser.sqlfilename  = args[0];

        int ret = sqlparser.getrawsqlstatements();
        if (ret == 0){
            for(int i=0;i<sqlparser.sqlstatements.size();i++){
                System.out.println(sqlparser.sqlstatements.get(i).sqlstatementtype.toString());
                System.out.println(sqlparser.sqlstatements.get(i).toString());
                System.out.println();
            }
        }else{
            System.out.println(sqlparser.getErrormessage());
        }

Download this dem: Java version

## Leave a Reply

Your email address will not be published. Required fields are marked *

Name *

Email *

Website

Add Comment

Save my name, email, and website in this browser for the next time I comment.

I accept the Privacy Policy