Files_To_Table

Returns a list of files as a table

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

Syntax:

EXEC SQLHTTP.net.Files_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
FileName	varchar(4000)	The Name of the file



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 @Files TABLE(RowID bigint, [FileName] nvarchar(4000))

INSERT INTO @Files(RowID, [FileName])
EXEC SQLHTTP.net.Files_To_Table 'C:\Windows'

SELECT TOP 5 *
FROM @Files

SET NOCOUNT ON

DECLARE @Files TABLE(RowID bigint, [FileName] nvarchar(4000))

INSERT INTO @Files(RowID, [FileName])

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

SELECT TOP 5 *

FROM @Files

RowID FileName

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

1 c:\Windows\bfsvc.exe

2 c:\Windows\bootstat.dat

3 c:\Windows\comsetup.log

4 c:\Windows\diagerr.xml

5 c:\Windows\diagwrn.xml



Files_To_Table

Featured API Wrapper Code / SQL Server