Using for loop bat file windows for multiple command calls

Question

I want to export all data from sql server table to a csv, I know I can get the desired result by:

sqlcmd -S . -d database -E -s, -W -Q "SELECT * FROM TABLENAME" > file.csv

I have many tables, so I want to create a .bat file that do the work for me, I have this:

set "list = A B C D"


for %%x in (%list%) do (
    sqlcmd -S . -d database -E -s, -W -Q "SELECT * FROM %%x" > %%x.csv

)

But I am getting errors I don't know (I am not an expert in bat files). Why this does not work? How can I do what I want?

Possible duplicate of Declaring and using a variable in DOS/Windows batch file (.BAT) — aschipfl
– aschipfl, Commented May 3, 2016 at 16:03

rojo · Accepted Answer · 2016-05-03 16:00:12Z

6

Spacing is important when using set (unless you're doing math with the /A switch). As written, the variable you're setting isn't %list%. It's %list %. Change your set command as follows:

set "list=A B C D"

answered May 3, 2016 at 16:00

rojo

24.5k5 gold badges61 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using for loop bat file windows for multiple command calls

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related