我写了一个SQL SERVER自己导入数据的bat 文件,但就是不执行??
我写了一个bat文件,想自动导入数据文件:
内容如下
@echo off
echo 232323
set var=%time:~0,2%
set/a var1=var-1
set var3=%date:~2,2%%date:~5,2%%date:~8,2%%var1%
echo %var3%
osql -S localhost -U sa -P zhangconggang -d store
go
-q select * from a111_log
BULK INSERT [dbo].[a111_log] FROM 'D:\WINDOWS\system32\Logfiles\W3SVC1\ex%var3%.log' WITH (FIELDTERMINATOR =' ',KEEPIDENTITY)
go
pause