Howto add a string to the 'type <filename>' DOS command before merging into file ?

Question

Question: I've several text files containing sql create table/column/view/storedProcedure textfiles. Now I want to merge the textfiles into one textfile.

I go into the directory, and type:

type *.sql >> allcommands.sql

Now to problem is I should add the text ' GO ' after every file's content.

I can append Go by doing

type *.sql >> allcommands.sql & echo  GO  >> allcommands.sql

But this only inserts go once. How can I accomplish this with DOS commands ?

Answer 1

Use copy to concatenate the first file with a file with "GO" text, then concatenate again with the second file.

Answer 2

You want something like this:

for %%f in (*.sql) do type %%f >>allcommands.sql & echo GO >> allcommands.sql

The %% is for use in a batch file. If you're not running it from a batch file you only need single % signs.