SQL »ñȡϵͳÎļþ

--»ñµÃµ±Ç°ËùÓÐÇý¶¯Æ÷
exec master.dbo.xp_availablemedia
--»ñµÃ×ÓĿ¼Áбí
exec master.dbo.xp_subdirs 'c:\'
--»ñµÃËùÓÐ×ÓĿ¼µÄĿ¼Ê÷½á¹¹
exec master.dbo.xp_dirtree 'c:\'
--¶©ÔÄÎļþɾ³ý
declare @tempTable table (Cont varchar(50))
declare @strTemp varchar(50)
declare @dirPath varchar(50)
declare @dirOrder varchar(50)
declare @delpath varchar(50)
declare @delOrder varchar(50)
set @dirPath = 'C:\ddt\unc\ZF_TEST_BB\'
set @dirOrder = 'dir '+@dirPath
set @delpath = 'rd/q/s '+@dirPath
insert into @tempTable(Cont) exec master.dbo.xp_cmdshell @dirOrder
DECLARE authors_cursor CURSOR FOR
 select Cont from @tempTable
 where (Cont not like '%'+CONVERT(varchar(50),month(GETDATE()))+'-'+CONVERT(varchar(50),day(GETDATE()))+'%')
 and (Cont like '%'+CONVERT(varchar(50),year(GETDATE()))+'-%')
 OPEN authors_cursor
  FETCH NEXT from authors_cursor into @strTemp
  While @@FETCH_STATUS = 0
  Begin
   set @delOrder = @delpath+ right(@strTemp,14);
   print @delOrder
--   exec master.dbo.xp_cmdshell @delOrder
  FETCH NEXT from authors_cursor into @strTemp
  End
 CLOSE authors_cursor
DEALLOCATE authors_cursor