Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Load directory listing into table
Message
De
25/01/2012 11:54:12
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Load directory listing into table
Divers
Thread ID:
01533716
Message ID:
01533716
Vues:
76
Hi

I'm using
insert into tempdb.dbo.scan_file_list
exec xp_cmdshell 'dir C:\test\ *.* /b'
to try and load a list of filenames into a tble.

But I get other for instance files from the windows system directory included .

What am I doing wrong.

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform