SQL Server: How to Check if a File Exists in a Directory | a Tech-Recipes Tutorial

Frequently, when working with SQL, we need to know if a file exists in a local directory or not. This can be done using SQL Server’s built-in procedure known as master.dbo.xp_fileexist. This user-defined function (UDF) checks whether or not a file exists

www.tech-recipes.com