IsExistingFile

Checks for the existence of a single file.

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

Syntax:

SELECT SQLHTTP.net.IsExistingFile( @FilePath )

Arguments:

Name	Type	Description
@FilePath	varchar(MAX)	Full path to an existinge file



Return Type:

bit



Return Values:

0 = File does NOT exist
1 = File 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 @FilePath varchar(MAX)

--Assign a path to a file that the executing user has read permissions on
SET @FilePath = 'C:\ThisFileDoesNotExist.txt'

SELECT SQLHTTP.net.IsExistingFile(@FilePath)

DECLARE @FilePath varchar(MAX)

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

SET @FilePath = 'C:\ThisFileDoesNotExist.txt'

SELECT SQLHTTP.net.IsExistingFile(@FilePath)

-----



IsExistingFile

Featured API Wrapper Code / SQL Server