SQLService 脚本执行CMD文件复制

云博小周宇2024年5月5日2023年8月18日1 Min Read

SET STATISTICS PROFILE ON SET STATISTICS IO ON SET STATISTICS TIME ON DECLARE @COUNT INT =1 WHILE (@COUNT<200) BEGIN
declare @cmd varchar (1024) 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