替代方法在SQL Server中使用SQL Server

xp_cmdshell 存储过程。 However, in certain scenarios, we may prefer to avoid using this procedure.

An Alternative Approach: xp_dirtree

xp_dirtree stored procedure as an alternative solution for listing files inside a folder.此存储过程需要三个参数： root directory路径

Options

1. Usage Example
2. To illustrate the usage of xp_dirtree
, let's execute the following command:
3. EXEC xp_dirtree 'C:\', 2, 1
In this example, we're specifying the root directory as 'C:\', setting the depth to 2 (which will list files and folders up to two subdirectories deep), and opting to display only folders by setting the third parameter to 1.