Count files with SQL

[batteam]

I would like to use SQL to count the number of files in a folder. Does anyone have the SQL commands to do this, if possible? Thanks in advance for any help you can offer.

 

[bborissov]

WHY?

Borislav Borissov
VFP9 SP2, SQL Server

 

[simian336]

drop table #test

CREATE TABLE #test (
t2 varchar( 255),
)

INSERT INTO #test
exec xp_cmdshell 'dir /b d:\'
go

select *
from #test
where t2 is not null

select count(*)
from #test
where t2 is not null

Simi

 

[simian336]

ps... xp_cmdshell is not enabled by default so you will have to enable it and have permissions to run it.

Just Google it for those instructions.

Simi