how to get the filenames from the specified directory using sql server?

Question

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

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

Derrick Leggett SSCrazy Points: 2778 More actions · Answer 1

?? EXEC xp_cmdshell 'dir c:\whatever\'

Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.

Gopinath-155584 SSC Enthusiast Points: 178 More actions · Answer 2

Hi,

But i want to store the filenames in the temporary table. If I pass the value directory from the particular drive...

Regards

-Gopi

Derrick Leggett SSCrazy Points: 2778 More actions · Answer 3

DECLARE

@directory NVARCHAR(255),

@sql NVARCHAR(2000)

IF (SELECT OBJECT_ID('tempdb..#cmdshell')) IS NOT NULL

BEGIN

DROP TABLE #cmdshell

END

CREATE TABLE #cmdshell(results VARCHAR(8000))

SELECT @directory = 'c:\'

SELECT @sql = 'dir '+ @directory + ' /B /A:-D'

INSERT #cmdshell(results)

EXEC xp_cmdshell @sql

SELECT results FROM #cmdshell

Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.

Gopinath-155584 SSC Enthusiast Points: 178 More actions · Answer 4

thanq very much. it's working fine. onece again thanq

Regards

-Gopi

philcart SSC-Forever Points: 47794 More actions · Answer 5

For a far simpler method, check the answer to one of my past posts,

--------------------
Colt 45 - the original point and click interface