SQL Eval Function Directory_Exists
Directory_Exists determines whether the given path refers to an existing directory on disk.
Directory_Exists ( @path NVARCHAR (MAX) ) RETURNS BIT
Parameters
- path: The path to test.
Returns
true if path refers to an existing directory; false if the directory does not exist or an error occurs when trying to determine if the specified directory exists.
Example
SELECT SQLNET::Directory_Exists('C:\Temp')