问题如标题,原因是我的一个bat文件里有几个地方都调用了osql
..............
SET pat=%CD%test\HXGL.bak
@echo isql create job start>>log.txt
osql -E -S %Userver% -i"处理文件\sql2005\a.sql" -o"log.txt"
@echo isql create job end>>log.txt
.................
@echo isql create job start>>log.txt
osql -E -S %Userver% -i"restore db form disk =N'%pat%' With FILE = 1, NOUNLOAD, REPLACE, STATS = 10"" >log.txt
@echo isql create job end>>log.txt
..................................
@echo isql create job start>>log.txt
osql -E -S %Userver% -i"处理文件\sql2005\b.sql" -o"log.txt"
@echo isql create job end>>log.txt
我运行的时候中间的 osql里面的%pat%值取得是空的,为什么啊?
..............
SET pat=%CD%test\HXGL.bak
@echo isql create job start>>log.txt
osql -E -S %Userver% -i"处理文件\sql2005\a.sql" -o"log.txt"
@echo isql create job end>>log.txt
.................
@echo isql create job start>>log.txt
osql -E -S %Userver% -i"restore db form disk =N'%pat%' With FILE = 1, NOUNLOAD, REPLACE, STATS = 10"" >log.txt
@echo isql create job end>>log.txt
..................................
@echo isql create job start>>log.txt
osql -E -S %Userver% -i"处理文件\sql2005\b.sql" -o"log.txt"
@echo isql create job end>>log.txt
我运行的时候中间的 osql里面的%pat%值取得是空的,为什么啊?
