register
login
shopping cart
0 items in cart
Tweet
function libraries, tools and services for Microsoft SQL Server
Contact Us
Support
NoSQL vs SQL
Purchase
Download
Products
Home
SQLUtilities
SQLFinancials
SQLStatistics
SQLRollingStats
SQLMath
SQLEngineering
SQLDistributions
SQLFile
SQLTuples
Assembly Manager
Bespoke Assemblies
Data Migration
Data Cleansing
Database Design
Business Intelligence
Application Design
Features
Overview
Pricing
Documentation
SQLFile
External file and directory management
with quick data importing and exporting
Edit
Read, write & update multiple files & directories in parallel
Read entire file contents as single scalar binary or text values.
Read text file contents as single-column tables (1 row per line).
Read & parse character-delimited text files as multi-column tables.
Export single scalar binary or text values as whole files.
Append scalar text values to existing files.
Write character-delimited text files directly from tables, view or ad-hoc queries.
Compress / decompress text or binary values within the database for more efficient storage.
Create cryptographically secure unique random file & directory names.
Create uniquely-name temporary files in the system temporary folder.
Retrieve directory contents listings as single or multi-column tables - with optional recursion.
Encrypt or decrypt files in the file system.
Copy, move, replace, delete, & check the existence & size of files.
Create, move, delete, check for existence of & get parent or root of directories.
Read or set file attributes (e.g. readonly, hidden, system, archive, temporary, offline, compressed, encrypted).
Read or set timestamps on files and directories (created, last accessed, last written).
Check, create, alter, remove or purge access and audit rules for files and directories.
Compress / decompress scalar binary and text values.
Convert large binary objects between their binary, Base64 text and Hexadecimal text representations.
Convert text file contents between different code pages / encodings.
Retrieve drive type, volume, format, readiness, available free space, total free space & size information.
Parse file path strings to retrieve directory name, file name, file extension, root folder information.
Easily alter & combine path strings & test for validity (without accessing the file system).
Return as a table a list of logical drives on the server.
Request Callback
Buy Online
Download Trial
Talk to Us
Next Steps:
My Account
Privacy Policy
Terms of Use
Partners