How to list files inside a folder with SQL Server

by

You can use xp_dirtree

It takes three parameters:

Path of a Root Directory,
Depth up to which you want to get files and folders and
the last one is for showing folders only or both folders and files.

EXAMPLE: EXEC xp_dirtree 'C:\', 2, 1

More Related Contents:

  1. Can anyone help me to get the query to retrieve data like below [closed]
  2. NOT IN vs NOT EXISTS
  3. Simple way to transpose columns and rows in SQL?
  4. Only inserting a row if it’s not already there
  5. Optimal way to concatenate/aggregate strings
  6. How can I delete using INNER JOIN with SQL Server?
  7. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  8. Most efficient way in SQL Server to get date from date+time?
  9. Convert varchar into datetime in SQL Server
  10. TSQL Pivot without aggregate function
  11. Fastest way to perform nested bulk inserts with scope_identity() usage?
  12. SQL performance on LEFT OUTER JOIN vs NOT EXISTS
  13. Why are there gaps in my IDENTITY column values?
  14. Stored Procedure with optional “WHERE” parameters
  15. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  16. How do I perform a GROUP BY on an aliased column in SQL Server?
  17. How to write UPDATE SQL with Table alias in SQL Server 2008?
  18. SQL Server 2008- Get table constraints
  19. Restrict an SQL Server connection to a specific IP address
  20. Search for “whole word match” with SQL Server LIKE pattern
  21. Why are logical reads for windowed aggregate functions so high?
  22. Can SQL Server Express LocalDB be connected to remotely?
  23. SQL – Call Stored Procedure for each record
  24. Group All Related Records in Many to Many Relationship, SQL graph connected components
  25. SQL – How do I get only the numbers after the decimal?
  26. How to retrieve records for last 30 minutes in MS SQL?
  27. Group consecutive rows of same value using time spans
  28. Connecting to Oracle Database using Sql Server Integration Services
  29. Why do SQL Server Scalar-valued functions get slower?
  30. Executing SQL query on multiple databases

Leave a Comment