Technical Article

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.

You rated this post out of 5. Change rating

2002-03-05

458 reads

Blogs

THAT Conference 2024 in Wisconsin Dells

By

I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is...

7 Best Online Advanced SQL Training Courses to Learn in 2024

By

The world runs on data, and SQL is the key to unlocking its secrets....

Calling a REST Endpoint from Azure SQL DB

By

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Read the latest Blogs

Forums

Thinking About Technology

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thinking About Technology

SQL Server on Linux Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server on Linux Restrictions

Error fetching data via Linked Server

By Ram

Hi, SS ver: SS 2017, SE; Oracle: 19.23 SE We have a nightly job...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers