SQL SERVER – Running Multiple Batch Files Together in Parallel
- by pinaldave
Recently I was preparing a demo for my next technical session, I had to do run a SQL code in parallel. I decided to use Batch File to run the code.
I am not the best guy to with command shell so I did it with following setup.
Code of tsql.sql
SELECT 1 ColumnName
Code of command.bat
sqlcmd -S . -i tsql.sql
timeout 100
Code of AllBatch.bat…