File Access Stored Procedures for SQL Server 2005 and later (.NET)

Library overview

Use this library to do the following in T-SQL: Work with drives, directories, and files Read and write files as random binary data blocks or line-by-line as text Import BLOB data from disk files to table fields of TEXT/NTEXT/IMAGE datatype This extended stored procedures library targets SQL Server 2005 and later. It is built on .NET technology and thus the same library code can run on 32 bit and 64 bit SQL Server versions. These stored procedures are packaged in a dynamic-link library, xpFileUtils.Net.DLL. This 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 xpn_DirCreate, but this procedure immediately exits in the Standard edition.

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 & directory access
Std	Pro	Procedure	Description
		xpn_DirCreate	Creates a new directory.
		xpn_DirExists	Checks if a directory exists.
		xpn_DirRemove	Deletes a directory.
		xpn_DirSize	Returns size of directory and its subdirectories (in bytes).
		xpn_GetDriveSpace	Returns total drive size and its free space size (in bytes).
		xpn_GetDriveType	Determines whether a disk drive is a removable, fixed, CD-ROM, RAM disk, or network drive.
		xpn_GetLogicalDrives	Retrieves a bitmask representing the currently available disk drives.
		xpn_GetTempDir	Returns the path to Windows TEMP directory.
File access
Std	Pro	Procedure	Description
		xpn_FileAppendLine	Opens a text file, appends a line to the end of this file, and then closes this file.
		xpn_FileClose	Closes the file opened by xpn_FileOpen.
		xpn_FileConvert	Converts the file contents from UNICODE into UTF8 and vice versa.
		xpn_FileCompare	Compares the content of two files byte-to-byte.
		xpn_FileCopy	Copies a file to another location.
		xpn_FileDelete	Deletes a file.
		xpn_FileExists	Checks if a file exists.
		xpn_FileMove	Moves or renames a file.
		xpn_FileOpen	Opens a file for read and/or write access.
		xpn_FileReadBinary	Reads binary data from an arbitrary position of a file opened by xpn_FileOpen.
		xpn_FileReadChars	Reads character data from an arbitrary position of a file opened by xpn_FileOpen.
		xpn_FileReadContent	Returns the entire content of a file as a BLOB recordset field.
		xpn_FileReadLine	Reads text file line-by-line.
		xpn_FileSeek	Moves current position of read/write operation for a file opened by xpn_FileOpen.
		xpn_FileSize	Returns file size (in bytes).
		xpn_FileWriteBinary	Writes binary data to an arbitrary position of file opened by xpn_FileOpen.
		xpn_FileWriteChars	Writes character data to an arbitrary position of file opened by xpn_FileOpen.
		xpn_FileWriteLine	Writes a line to the end of the file opened by xpn_FileOpen.
		xpn_FindFiles	Finds files by a wildcard mask and returns found files as a recordset.
		xpn_GetTempFile	Returns a temporary file name.

Get It From 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.

Related Documents