How to call a stored procedure in SQL to delete a directory. . The directory contains files?

tzdt9v

EXEC XP_CMDSHELL 'DEL D:\A\*. *' This command returns to ask whether to delete

EXEC XP_CMDSHELL 'DEL D:\A\*. * / Y' This is also wrong!

EXEC XP_CMDSHELL 'RD D:\A' Delete empty directory and execute


Please master how to delete the entire directory, including the files inside

cv4bf5d65fd

delete tree D:\A

vgf10002

del tree

prajna

1st floor right ~

lilily

upstairs

hurricane6

There doesn't seem to be a good way. Deltree is not available in all systems. It is not available in 2000. It is not known in 2003.

kxiaper

That's it
EXEC MASTER..XP_CMDSHELL 'RD D:\A\/ S / Q'

/ S includes subdirectories
/ Q does not require confirmation

tzdt9v

No, the returned result is:

 'deltree' is not an internal or external command, nor is it a runnable program
 Or batch files.
 NULL

Is there any other way? ? DELTREE I have tried it, no

小老鹰

--try

exec master: .xp_cmdshell 'RD D:\A / S / Q'

toogun

exec master..xp_cmdshell is very strong, just like dos learned in our school