Populate a table with a directory's file info.

I use this SP to return full directory information into a table.  FilePath, FileName, Filedate and FileSize are parsed from a 'dir /n/on/-c ' command. FilesInDir is the table created. usage: exec LoadFileDetailsIntoTable 'c:\winnt'select * from FilesInDir where filesize > 100000select min(fileDate) from FilesInDirThe Return Code will equal the number of files found.

2002-03-05

452 reads

Blogs

ConFoo–The Future of Database Development in Containers

By

I delivered a talk at the ConFoo conference. I’ve never been to this live,...

Daily Coping 25 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Read the latest Blogs

Forums

Shortcutting Git Commands

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Shortcutting Git Commands

What's a Lot of Money?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's a Lot of Money?

Newb - SQL Server IIF() Function

By FGJ

I am using the following function: IIf([var1Title] != '', [var1Title] + ' - '...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers