File Access Stored Procedures for SQL Server 7.0, 2000, 2005 and later (Win32)

Library overview (version 1.1.0.2)

Use file system from T-SQL and do even more: Direct file system access: Work with disk drives, directories, and files; Read and write files (random binary data blocks or line-by-line as text); Export and import BLOB data from disk files to table fields of TEXT/NTEXT/IMAGE datatype; Work with INI files; Compress and decompress memory data; Create and verify MD5 or SHA hashes; Encrypt and decrypt data (using RC2, RC4, or DES); Access resources in the internet; Format string templates (like C++ sprintf or Delphi Format functions do). This extended stored procedures library works with SQL Server 6.5, 7.0, 2000, 2005, and later. The library is a native Win32 DLL and thus can run only on a 32 bit SQL Server. See also xpFileUtils for SQL Server 2005 32 and 64 bit The library is available in 2 editions: Professional Edition: How To Buy Standard Edition: FREE The Standard and Professional editions include all the procedures (listed below), but only the Professional edition implements all the procedures. For example, it is possible to call xp_DirCreate, but this procedure immediately exits in the Standard edition.

Get It Here!

1. Download FREE Standard Edition (500K download size) including sample scripts and a comprehensive reference manual in CHM format.
2. Read our Privacy Policy and Order Processing information.
3. Buy the Professional Edition using a safe payment processing service from Share*it!. Volume discount prices available.

Stored procedures list

The extended stored procedures are grouped by category where each category provides stored procedures' names, their descriptions and availability in Std and Pro Editions.

Drive and directory access
Procedure	Description	Std	Pro
xp_DirCreate	Creates a new directory.
xp_DirExists	Checks if a directory exists.
xp_DirRemove	Deletes a directory.
xp_DirSize	Returns size of directory and its subdirectories (in bytes).
xp_GetDriveSpace	Returns total drive size and its free space size (in bytes).
xp_GetDriveType	Determines whether a disk drive is a removable, fixed, CD-ROM, RAM disk, or network drive.
xp_GetLogicalDrives	Retrieves a bitmask representing the currently available disk drives.
xp_GetTempDir	Returns the path to Windows TEMP directory.
File access
Procedure	Description	Std	Pro
xp_FileAppendLine	Opens a text file, appends a line to the end of this file, and then closes this file.
xp_FileClose	Closes the file opened by xp_FileOpen.
xp_FileConvert	Converts the file contents from UNICODE into UTF8 and vice versa.
xp_FileCompare	Compares contents of two files byte-by-byte.
xp_FileCopy	Copies a file to another location.
xp_FileDelete	Deletes a file.
xp_FileExists	Checks if a file exists.
xp_FileMove	Moves or renames a file.
xp_FileOpen	Opens a file for read and/or write access.
xp_FileRead	Reads data from an arbitrary position of a file opened by xp_FileOpen.
xp_FileReadContents	Returns the entire file contents as a blob recordset field or as a number of output params.
xp_FileReadLine	Reads text file line-by-line.
xp_FileSeek	Moves current position of read/write operation for a file opened by xp_FileOpen.
xp_FileSize	Returns file size (in bytes).
xp_FileWrite	Writes data to an arbitrary position of file opened by xp_FileOpen.
xp_FileWriteLine	Writes a line to the end of the file opened by xp_FileOpen.
xp_FindFiles	Finds files by a wildcard mask and returns found files as a recordset.
xp_GetTempFile	Returns a temporary file name.
Compression and decompression These procedures can compress and decompress custom data using LZ compression algorithm.
Procedure	Description	Std	Pro
xp_ZCreate	Creates an internal compressor/decompressor object.
xp_ZAppend	Incrementally adds data to be compressed/decompressed to an internal buffer. This allows to process data streams larger than 8KB.
xp_ZCompress	Compresses data and returns result as a single row recordset.
xp_ZDecompress	Decompresses data and returns result as a single row recordset.
xp_ZClose	Destroys the object returned by xp_ZCreate.
Cryptography These procedures use Microsoft Cryptographic API (CryptoAPI). They can create and verify hashes (using MD5 or SHA), and encrypt and decrypt data (using RC2, RC4 or DES).
Procedure	Description	Std	Pro
xp_HashCreate	Creates a new hash object (MD5 or SHA) and returns a handle on it.
xp_HashAppend	Appends data to hash. This allows to process data streams larger than 8KB.
xp_HashClose	Returns hash value and then closes the hash handle.
xp_md5_quick	Returns MD5-hash on a given value.
xp_md5_quick_compare	Checks if a given value is OK to a given MD5-hash.
xp_sha_quick	Returns SHA-hash on a given value.
xp_sha_quick_compare	Checks if a given value is OK to a given SHA-hash.
xp_symmetric_quick_encode	Encodes data with password using either RC2, RC4 or DES algorithm.
xp_symmetric_quick_decode	Decodes data protected with password using either RC2, RC4 or DES algorithm.
xp_GetRandomData	Returns random bytes data value of a specified length.
Internet access
Procedure	Description	Std	Pro
xp_IsPortOpen	Checks if a given host name has the given port open.
xp_GetAddrByHost	Returns the IP address for the given host name.
xp_GetHostByAddr	Returns the host name for the given IP address.
xp_CanPing	Only checks if the destination host can be pinged (e.g. reachable).
xp_Ping	Returns full statistics of ping operation like ping.exe utility does.
xp_TraceRoute	Returns full statistics of trace route operation like tracert.exe utility does.
xp_Whois	On a given internet address, performs requests to international WHOIS databases and returns any available registration data.
INI-file access
Procedure	Description	Std	Pro
xp_IniDeleteKey	Deletes a key from INI file.
xp_IniDeleteSection	Deletes a section from INI file.
xp_IniReadKey	Reads a key value from INI file.
xp_IniWriteKey	Writes a key value to INI file.
Format string templates
Procedure	Description	Std	Pro
xp_FormatStr	Formats strings in C++/Delphi style, like sprintf() or Format() do.

Related Documents