:: 关闭终端回显
@echo off
set CURRENT_DATE_STRING=DataBAK+%date:0,4%%date:5,2%%date:~8,2%
echo CURRENT_DATE_STRING=%CURRENT_DATE_STRING%
set CURRENT_TIME_STRING=%time:0,2%_%time:3,2%_%time:~6,2%
echo CURRENT_TIME_STRING=%CURRENT_TIME_STRING%
set CURRENT_DATE_TIME_STRING=%CURRENT_DATE_STRING%_%CURRENT_TIME_STRING%
echo CURRENT_DATE_TIME_STRING=%CURRENT_DATE_TIME_STRING%
:: 创建文件夹
md D:\Data%CURRENT_DATE_TIME_STRING%
bcp pos..Spgood out d:\data%CURRENT_DATE_TIME_STRING%\Spgood.txt -c -S. -Usa -PCS123 >>log_out.txt
echo "表名:.Spgood" >>log_out.txt"
BCP导出的文件不能直接到:%CURRENT_DATE_TIME_STRING% 动态文件名目录下:因:BCP不支持:此语法;
%CURRENT_DATE_TIME_STRING% 转换后也不能在动态文件目录下:请大佬指教!非常感谢!我就是一个初来报到的菜鸟!