Forums Register Login
end of batch indicators (';' and 'GO')
I am building a script running utility and have a question about end of batch 'signals' in scripts that contain multiple batches. That is, symbols like ';' (semi-colon used by Oracle and DB2) or the 'GO' (used by SQL Server), used to separate multiple batches within a single script file.
Can anyone suggest how to handle multiple batches within a single script file? I would simply like to read in the script file to a string and run it, but I know this will cause the SQL statement to fail. I am figuring I will need to parse this somehow while reading in the file.
Am I on the write track? Or can someone suggest a better or simpler, or more eligant solution? Not necessarily the details, but a push in the right direction would be nice.
Our first order of business must be this tiny ad:
RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database

This thread has been viewed 604 times.

All times above are in ranch (not your local) time.
The current ranch time is
Feb 19, 2019 19:50:20.