DAIC

osql -E -q "SELECT COUNT(1) FROM dbo.Extract_Paymentech_Exchange_Billing WHERE FileName =" + %FileName% > %temp%\a.txt
set /p str=<%temp%\a.txt
echo,%str%
复制代码

DAIC

回复 4# leoaqi

for /f %%i in ('osql -E -q "SELECT COUNT(1) FROM dbo.Extract_Paymentech_Exchange_Billing WHERE FileName =" + %FileName%') do (
    set recordscount=%%i
)
echo,%recordscount%
复制代码

不行的话，就加上转义符号试试：

for /f %%i in ('osql -E -q "SELECT COUNT^(1^) FROM dbo.Extract_Paymentech_Exchange_Billing WHERE FileName ^=" ^+ %FileName%') do (
    set recordscount=%%i
)
echo,%recordscount%
复制代码

再不行的话，就把执行过程发出来给我看看。

DAIC

回复 6# leoaqi


    能否详细讲解一下好在哪里？