yslyxqysl

@echo off
setlocal ENABLEDELAYEDEXPANSION
set /a m=1
for /F "usebackq skip=2 tokens=1,2,3" %%i in ("%log%\sp.log") do  (
    set /a m += 1
)                   

set count=1
for /F "usebackq skip=2" %%i in ("%log%\sp.log") do  (
    echo Backing up Store Procedure %%i                          >> "%log%\backup_all_sp_%db%_%srvname%_%year%%mon%%day%_%hour%%min%%ss%.log"                                         
   sqlcmd -S%srvname% -d%db% -U%user% -P%password% -Q "select text from syscomments where id=object_id(%%i)" -o "%bak%\%srvname%_%db%_%%i_%year%%mon%%day%_%hour%%min%%ss%.PRC"
    echo ... Finished:  !count!/%m% ...
    set /a count += 1 
)
复制代码