日期:2014-05-17 浏览次数:20487 次
@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