Optional GO after each set of INSERT's

Apr 15, 2009 at 9:20 PM
In addition to my other change, I added the following line after current line 336:
 
    WriteLine 'GO' $file

to change this:

INSERT INTO HR.regions(region_id, region_name) VALUES(1, 'Europe');
INSERT INTO HR.regions(region_id, region_name) VALUES(2, 'Americas');
INSERT INTO HR.regions(region_id, region_name) VALUES(3, 'Asia');
INSERT INTO HR.regions(region_id, region_name) VALUES(4, 'Middle East and Africa');

to this:

INSERT INTO HR.regions(region_id, region_name) VALUES(1, 'Europe');
INSERT INTO HR.regions(region_id, region_name) VALUES(2, 'Americas');
INSERT INTO HR.regions(region_id, region_name) VALUES(3, 'Asia');
INSERT INTO HR.regions(region_id, region_name) VALUES(4, 'Middle East and Africa');
GO