Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 test if multiple files exist

Author  Topic 

dlh
Starting Member

28 Posts

Posted - 2010-03-05 : 16:37:30
I have a column of filenames. Is there a T-SQL way to generate a Boolean column which tells whether or not the corresponding files actually exist?

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2010-03-05 : 16:43:55
Use CASE Statement to write a Query

With Regards
SR
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2010-03-05 : 17:32:06
Function F_CHECK_IF_FILE_EXISTS
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140933

CODO ERGO SUM
Go to Top of Page

dlh
Starting Member

28 Posts

Posted - 2010-03-05 : 18:42:06
Thank you, Michael. I had been trying to do it without creating a function. That makes it much easier.
Go to Top of Page
   

- Advertisement -