sqlcmdで任意のフォルダ配下のクエリを実行

.bat

@echo off

REM DIR_NAME配下のSQL文実行

REM -------初期値設定-----
set SERVER_NAME=hoge\SQLEXPRESS
set DB_NAME=fuga
set USER_NAME=poyo
set PASS_WORD=peyo
set DIR_NAME=D:\HOME\DB\SRC
REM ----------------------


for /R %DIR_NAME% %%a in (*) do (

sqlcmd  -e -S %SERVER_NAME% -d %DB_NAME% -P %PASS_WORD% -U %USER_NAME% -i %%a

)

pause