Home » Tip Bank » Database Development » SQL » Transact-sql

Language: Enterprise
Expertise: Intermediate

Dec 14, 2001

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 int
exec master..xp_fileexist 'c:\screen.jpg' , @myfile out
select @myfile as FileStatus
--//////////////////////////////////

If "FileStatus" is "1", the file is available for use.