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:

See Also: