SQLSERVER 执行Windows命令 (总结版)

丨我是张先生丨

已于 2024-01-29 14:14:41 修改

阅读量554

点赞数 9

文章标签：服务器 sql

于 2024-01-29 13:35:07 首次发布

本文链接：https://blog.csdn.net/AgonyQAQ/article/details/135910380

版权

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 '