[文件操作] 求助：数据库取值赋值给批处理变量

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%
复制代码

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

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%
复制代码

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