DosTips.com

The result is line-c+1.sql having the following content: select * from table1 where col1 = 'A' and col2 = '1' ; select * from table1 where col1 = 'B' and col2 = '2' ; select * from table1 where col1 = 'C' and col2 = '3' ; can I have the 3 files instead? # line1.sql select * from table1 where col1 = ...

yes

I have a comma delimited input file param.txt: A,1 B,2 C,3 ...... I would like to create a batch file that: 1. read every lines of param.txt 2. and generate the sql like below for each line line1.sql: select * from table1 where col1 = 'A' and col2 = '1' ; line2.sql: select * from table1 where col1 =...