Search code examples
command-linebatch-filecmdcommand-promptsqlcmd

How to make a OR statement in a batch file?

Hi want to exclude 2 or more files from my batch file.

My batch file executes all SQL files in that folder.

Here is the code:

ECHO %USERNAME% started the batch process at %TIME% >output.txt 

FOR %%G IN (*.sql) DO (
//IF would go here to skip unwanted files
sqlcmd.exe  -S RMSDEV7 -E   -d ChaseDataMedia7 -i "%%G" >>output.txt
)

pause

So, how would i add and if statemant to skip the files in the loop that i don't want to execute?

Solution

  • You can chain IFs;

    FOR %%G IN (*.sql) DO (
   if not %%G==foo.sql if not %%G==bar.sql (
      some command "%%G"
   )
)