SQLService 脚本执行CMD文件复制
标签：class off sql char end cmdshell arc statistic varchar
SQLService 脚本执行CMD文件复制
SET @Cmd=(‘master.dbo.xp_cmdshell ‘+‘‘‘xcopy \\192.168.1.1\pic\DBMS-PIC\1\002-副本(‘+CONVERT(VARCHAR(10),@COUNT)+‘).jpg \\192.168.1.1\pic\DBMS-PIC\5\‘+‘‘+‘ /y/s‘+‘‘‘‘)
EXEC (@Cmd)
SET @COUNT=@COUNT+1
END
SET STATISTICS PROFILE OFF
SET STATISTICS IO OFF
SET STATISTICS TIME OFF