救救我吧

Question

create  procedure  删除硬盘文件
    @head varchar(13),
    @filepath    varchar(60),
    @startmonth varchar(2),
    @startday int,
    @daycount int    
as
    set nocount on
    declare  @filename varchar(50) ,@s varchar(8000)
    while @daycount>0
   begin
    select @filename=@head+@startmonth+dbo.maxnum(@startday)+'0101.txt'  
    set @s='del "'+@filepath+@filename+'"'
   exec  master..xp_cmdshell  @s
     
        
      select @daycount=@daycount-1
      select @startday=@startday+1
     
      print @filename+'已经完成'
    end
go exec 删除硬盘文件 'T2103100D2004','D:\g_6月\','07',2,7

Answer 1

create  procedure  删除硬盘文件
    @head varchar(13),
    @filepath    varchar(60),
    @startmonth varchar(2),
    @startday int,
    @daycount int    
as
    set nocount on
    declare  @filename varchar(50) ,@s varchar(8000)
    while @daycount>0
   begin
    select @filename=@head+@startmonth+dbo.maxnum(@startday)+'0101.txt'  
    set @s='del "'+@filepath+@filename+'"'
   exec  master..xp_cmdshell  @s
     
        
      select @daycount=@daycount-1
      select @startday=@startday+1
     
      print @filename+'已经完成'
    end
go exec 删除硬盘文件 'T2103100D2004','D:\g_6月\','07',2,7

Answer 2

问题出在这一行exec  master..xp_cmdshell  ' del @filepath+@filename+ '   自己比较一下吧