How can we help you today? How can we help you today?

SQL-Script - automatically add GO every xx lines

Hi,

I have a very large table to compare between databases. Sometimes there are 800,000 rows to insert in the new database.

When I script the 800,000 rows they are in one batch.
Is there any way to add a GO every 100 or 200 lines??? :roll:
So the execution of the script would be much faster.

Please help.
TSchwab
0

Comments

1 comment

Sort by
  • chris.buckingham
    The best way is to parse the SQL script with a utility to inject a GO after so many lines. You could easily use a VB or Perl script to do this.
    chris.buckingham
    0

Add comment

Please sign in to leave a comment.