Is it possible to findout the files in SQl server?

Question

Post reply

Is it possible to findout the files in SQl server?

Saravanan_tvr

SSCarpal Tunnel

Points: 4558
More actions
April 8, 2010 at 12:33 am

#213498

Hi,
In my table i have a column ie,
File Path values is "E\temp\a1.jpg"
Table1
Column name is Path
"E\temp\a1.jpg"
"E\temp\a2.jpg" etc...
Can we find that jpg is exist or not exist in Computer? is it possible in Sql server?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

you can use something like

Exec Master.dbo.xp_fileexist YOUR_COLUMN_NAME

Go thro this article to know more about xp_FileExist

http://www.sqlservercentral.com/articles/Stored+Procedures/xpfileexist/183/

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 2

Saravanan_tvr

SSCarpal Tunnel

Points: 4558

April 8, 2010 at 3:04 am

#1148099

THANKS GREAT.....

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 3

ColdCoffee

SSC-Dedicated

Points: 39972

April 8, 2010 at 12:03 pm

#1148534

Glad it helped you buddy 🙂

Cheers!!

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 4

As a side bar, try this and imagine the possibilities... 😉

EXEC Master.dbo.xp_Dirtree 'E:\temp',1,1

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 5

xp_Dirtree , an extended stored procedure looks like a very good option to check for the files and folder in directory. 🙂