INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Thank you again! I can't tell you how much I and my company appreciate what you've done! I love this place!..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Programming Forum

Count files with SQL

Read More Threads Like This One

batteam (Programmer)

18 Jun 12 9:57

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 (Programmer)

18 Jun 12 13:28

WHY?

Borislav Borissov
VFP9 SP2, SQL Server

simian336 (Programmer)

19 Jun 12 8:46

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 (Programmer)

19 Jun 12 8:51

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft SQL Server: Programming