SQLFile extends and enhances your T-SQL programming
environment by adding a suite of 117 functions to
support direct access to the file system from within T-
SQL scripts and stored procedures. SQLFile
capabilities include:

* Easy processing and manipulation of path and file
names (this can be done without file system access).

* Directory contents listings as table-valued
functions or results sets with optional subdirectory
recursion and pattern matching.

* Testing for existence of files and folders and
retrieving attributes, access control settings, file
sizes and timestamps.

* Copying, moving, replacing, renaming and changing
the attributes of files and directories.

* Simple import of file contents as binary objects,

Download (182 KB) Website Link to this page