SQLService 脚本执行CMD文件复制
时间：2021-07-01 10:21:17
帮助过：39人阅读
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
SQLService 脚本执行CMD文件复制
标签：class off sql char end cmdshell arc statistic varchar
