diandian82的专栏

/*Be careful of the path*/del log.outcd 01_SystemStoredProceduresfor %%f in (*.sql) do osql -S %1 -d %2 -n -E -i %%f >> ../log.outcd ../02_tablesfor %%f in (*.sql) do osql -S %1 -d %2 -n -E

sqlcmd -S LocalHost -E -i c:/test_DB.sql >>log.txt Here only specify the Server name, for the db name should be declared in the sql script. for more information, please see the command help