Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- :: Name: sql_execute.cmd
- :: Purpose: execute script.sql via sqlcmd
- :: Author: ettingshausen
- :: Revision: 2018/3/1 - initial version
- ::
- @ECHO OFF
- SETLOCAL ENABLEEXTENSIONS
- SET parent=%~dp0
- SET interactive=0
- SET sql_script="%parent%%1"
- ECHO %COMSPEC% | FINDSTR /L %CMDCMDLINE% >NUL 2>&1
- IF %ERRORLEVEL% == 0 SET interactive=1
- SET server="localhost"
- SET username="sa"
- SET password="root"
- :: execute script
- sqlcmd -S %server% -U %username% -P %password% -i %sql_script%
- IF "%interactive%"=="0" PAUSE
- EXIT /B %ERRORLEVEL%
Add Comment
Please, Sign In to add comment