devxlogo

Check for OS File Existence from T-SQL

Check for OS File Existence from T-SQL

Sometimes you may want to check whether a particular file is available while working with the file system in T-SQL. You can check this by using “xp_fileexist “, Sql Server Undocumented system stored procedure.

 --//////////////////////////////////declare @myfile intexec master..xp_fileexist 'c:screen.jpg' , @myfile outselect @myfile as FileStatus--//////////////////////////////////

If “FileStatus” is “1”, the file is available for use.

devx-admin

Share the Post: