T-SQL: list files in folder - 1 views

• 
  #1 Sergey Leifer on 07 Aug 10

   

  create table #Files (
  FullName nvarchar(255) null
  )
  
  insert #Files
  exec master..xp_cmdshell 'DIR C:*.csv /B /S'
  
  select right(FullName, patindex('%%', reverse(FullName)) - 1) as ShortFileName
  ,*
  from #Files
  where not FullName is null
  
  drop table #Files

   

  <div class="cArrow"> </div><div class="cContentInner">create table #Files ( <br /> FullName nvarchar(255) null <br /> ) <br /> <br /> insert #Files <br /> exec master..xp_cmdshell 'DIR C:*.csv /B /S' <br /> <br /> select right(FullName, patindex('%%', reverse(FullName)) - 1) as ShortFileName <br /> ,* <br /> from #Files <br /> where not FullName is null <br /> <br /> drop table #Files</div>

  ...

  Cancel

To Top