How to check a file exist on a particular path or not

/*provide you information that given file exists or not, file is a directory or not,
is there is any parent directory of file*/

EXEC xp_fileexist filpath

for eg. you have to check noname.txt file exsist on your c drive root or not

then
EXEC xp_fileexist 'c:\noname.txt'


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: