批处理bat执行sql脚本

set r=%time%
echo %r%开始导入 >>e:/c#/test.txt

osql -S (local) -U sa -P -d colorring -i e:/c#/11.sql >>d:/c#/test.txt

echo %r%导入完成 >>e:/c#/test.txt

 

 

其中11.sql中为

bulk insert  colorring..test from 'e:/c#/11.txt'
WITH (
FIELDTERMINATOR = ',',
ROWTERMINATOR ='/n'
)