SQLSERVER 执行Windows命令 (总结版)

EXEC Master..xp_cmdShell 'type F:\Test\123.csv'

EXEC Master..xp_cmdShell'echo "A","B","C","D","E","F","G","H","I","备注","note","2024/9/1","","10.01" >> F:\Test\123.csv'

EXEC Master..xp_cmdShell 'dir /b F:\Test\'
EXEC Master..xp_cmdShell 'dir F:\Test\' --不写 /b 输出文档详细信息
EXEC Master..xp_cmdShell 'copy  F:\Test\123.csv F:\bak'
EXEC Master..xp_cmdShell 'copy  [源文件路径] [目标路径]'
EXEC Master..xp_cmdShell 'type  F:\Test\123.csv'
EXEC Master..xp_cmdShell 'move  F:\Test\123.csv F:\bak'
EXEC Master..xp_cmdShell 'move  [源文件路径] [目标路径]'
EXEC Master..xp_cmdShell 'del [文件名]'
EXEC Master..xp_cmdShell 'ren [源文件] [目标文件]'
EXEC Master..xp_cmdShell 'rename  [源文件] [目标文件]'
EXEC Master..xp_cmdShell 'type nul > F:\Test\321.txt '