IsExistingFolder

Checks for the existence of a folder.

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.IsExistingFolder( @FolderPath )

Arguments:

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



Return Type:

bit



Return Values:

0 = Folder does NOT exist
1 = Folder EXISTS



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:


DECLARE @FolderPath varchar(MAX)

--Assign a path to a folder that the executing user has read permissions on
SET @FolderPath = SQLHTTP.net.TempPath()

SELECT SQLHTTP.net.IsExistingFolder(@FolderPath)

DECLARE @FolderPath varchar(MAX)

--Assign a path to a folder that the executing user has read permissions on

SET @FolderPath = SQLHTTP.net.TempPath()

SELECT SQLHTTP.net.IsExistingFolder(@FolderPath)

-----



IsExistingFolder

Featured API Wrapper Code / SQL Server