Prev: Convert string to uniqueidentifier?
Next: Help finding first payment date and amount
From: JMMB on 3 Jun 2010 11:20
Hi,

How can I customize the the FOR command below to loop through the files
inside the Database folder following the order of the number prefixed in the
file name?

FOR /R ../Database %%f IN (*.sql) DO sqlcmd -S %1 -d %2 -U %4 -P %5 -i
"%%~f" >> Logs/%2_DBInstall.log || goto errors

Database folder contains:
001_usp_procedure1.sql
002_ups_procedure2.sql

Thanks very much,


 | 
Pages: 1
Prev: Convert string to uniqueidentifier?
Next: Help finding first payment date and amount