Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Intermediate
Dec 14, 2001

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

If "FileStatus" is "1", the file is available for use.
Harinatha Reddy
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date