Folders_To_Table

Returns a list of folders as a table

Stored Procedure
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

EXEC SQLHTTP.net.Folders_To_Table @FolderPath

Arguments:

Name	Type	Description
@FolderPath	varchar(MAX)	Full path to an existing folder



Table Returned:

Column name	Data type	Description
RowID	int	Row Index
FolderName	varchar(4000)	The Name of the folder



Remarks:

Accessing the file system will be performed in the context of the SQL Server instance process. You can set SQL Server to run using a specific network account, or a Local System Account.



Sample Usage:


SET NOCOUNT ON

DECLARE @Folders TABLE(RowID bigint, FolderName nvarchar(4000))

INSERT INTO @Folders(RowID, FolderName)
EXEC SQLHTTP.net.Folders_To_Table 'C:\Windows'

SELECT TOP 5 *
FROM @Folders

SET NOCOUNT ON

DECLARE @Folders TABLE(RowID bigint, FolderName nvarchar(4000))

INSERT INTO @Folders(RowID, FolderName)

EXEC SQLHTTP.net.Folders_To_Table 'C:\Windows'

SELECT TOP 5 *

FROM @Folders

RowID FolderName

----------- ---------------------------

1 c:\Windows\addins

2 c:\Windows\appcompat

3 c:\Windows\AppPatch

4 c:\Windows\AppReadiness

5 c:\Windows\assembly



Folders_To_Table

Featured API Wrapper Code / SQL Server