Sqlcmd Using Batch Variable In Query

If I'm using sqlcmd in a batch script, can I reference a batch variable inside the query? So that if I do something like for /f 'delims= ' %%a in ('sqlcmd -S SERVER -d DATABASE -Q

Solution 1:

Change Column2=[var1] to Column2=%var1%

Solution 2:

You can pass arguments from the environment to sqlcmd by using the -v switch and referencing the parameters in your sql statement by the $(variable) syntax. E.g. in your second statement :

for /f "delims= " %%b in ('sqlcmd -S SERVER -d DATABASE -Q
    "SELECT Column2 FROM Table1 WHERE Column2=$(var1)" -v var1=%var1%'doset var2=%%b