怎么用SQL语句将指定目录的文件删除??? 在线等!!!(100分)

H

hetian_1982

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-21

• #1

我现在要将一些文件删除,要执行一个Job ,所以要用SQL语句!!大家帮帮忙!!

 

A

am2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-21

• #2

exec xp_cmdshell 'del c:/aaa.txt'

 

H

hetian_1982

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-21

• #3

am2001,
还是有点问题,如下
D:/MMSV1.0/Export/PRC/*.*，您確定要執行嗎 (Y/N)?

 

A

am2001

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-21

• #4

exec xp_cmdshell 'del c:/aa/*.* /Q'

 

H

hxt33

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-22

• #5

exec xp_cmdshell 'del c:/aa/*.txt'

 

H

hetian_1982

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-22

• #6

接受答案了.