Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how do you execute the fragment or sqlBatch using scriptdom

using (TextReader reader = new StringReader(script))
{
    TSqlParser parser = new TSql110Parser(true);
    IList<ParseError> errors;
    TSqlFragment fragment = parser.Parse(reader, out errors);
    if (errors != null && errors.Count > 0)
    {
        foreach (ParseError error in errors)
        {
            Console.WriteLine("Line: {0}, Column: {1}: {2}", error.Line, error.Column, error.Message);
            return;
        }
    }

    SqlScriptGenerator sqlScriptGenerator = new Sql110ScriptGenerator();
    TSqlScript sqlScript = fragment as TSqlScript;
    if (sqlScript == null)
    {
        sqlScriptGenerator.GenerateScript(fragment, Console.Out); // TODO execute the script
    }
    else
    {
        foreach (var sqlBatch in sqlScript.Batches)
        {
            Console.WriteLine("-- ");
            sqlScriptGenerator.GenerateScript(sqlBatch, Console.Out); // TODO execute the script
        }
    }
}
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL MAX() and MIN() in Nested SELECT 
Sql :: enable mysql remote connection to two specific ip address 
Sql :: To revoke create table from users 
Sql :: sql server split string and insert into table select 
Sql :: how to add column in oracle 
Sql :: get create sql of hibernqte entity 
Sql :: populate sql table with random data 
Sql :: SQL Create Named CHECK Constraint 
Sql :: java hide mysql login credentials 
Sql :: count record in same name condition 
Sql :: opensuse status MySQL 
Sql :: sql change date time from SGT to GMT 
Sql :: mysql offset from bottom 
Sql :: creating directory /var/lib/postgresql/data ... initdb: error: could not create directory "/var/lib/postgres/data": Permission denied 
Sql :: ring get columns count in the query result using the odbc_colcount() 
Sql :: mostrar datos de tablas relacionadas mysql kjava 
Sql :: sql dmv to capture updates 
Sql :: fill up postgres db 
Sql :: sql cursor example multiple columns 
Sql :: mysql table information 
Sql :: mysql select max and corresponding row 
Sql :: group by join columns per table 
Sql :: composite primary key sql 
Sql :: mysql auto increment jumping 
Sql :: does laravel validate sql 
Sql :: primary key start from number 
Sql :: sql server setup commands 
Sql :: oracle create job if not exists 
Sql :: sql query to delete row by id 
Sql :: doing calculations in mysql 
ADD CONTENT
Topic
Content
Source link
Name
2+8 =