22,209
社区成员
发帖
与我相关
我的任务
分享
declare @filename varchar(100),@s varchar(100)
set @filename='e:\mrp.xls'
set @s='master..xp_cmdshell ''del '+@filename+' '' '
exec (@s)
/*
output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL
(所影响的行数为 1 行)
*/
--如
exec master..xp_cmdshell 'del e:\2007.xls'
exec master..xp_cmdshell 'del d:\a.txt'