SQLCLR File Functions
Description
File Functions for SQL. Implemented as a SQLCLR assembly. Compatible with SQL 2008 and SQL 2008R2. May be compatible with SQL 2005, but untested.Copy File, Delete File, Delete Files, Get File Specs, Make Directory, Move File, Save File Image, Get File Image, and more!
Source Files
The download file nclsqlclrfile.zip has the following entries.
BuildProcessTemplates/DefaultTemplate.11.1.xaml
BuildProcessTemplates/LabDefaultTemplate.11.xaml
BuildProcessTemplates/UpgradeTemplate.xaml
FileManipulation-SQLCLR.sln/*from w w w . j a v a 2 s .c o m*/
FileManipulation-SQLCLR.vbproj
FileManipulation.snk
Functions-Scalar/MFBreakFileNameWithPathForFileName.vb
Functions-Scalar/MFBreakFileNameWithPathForFilePath.vb
Functions-Scalar/MFFileExistsCheck.vb
Functions-Scalar/MFFolderExistsCheck.vb
Functions-Scalar/MFGetFileImage.vb
Functions-TableValue/MFBreakFileNameWithPath.vb
Functions-TableValue/MFGetDirectoryList.vb
Functions-TableValue/MFGetFileSpecs.vb
My Project/AssemblyInfo.vb
Notes/MSP-ScalarFunctions.sql
Notes/MSP-Sprocs.sql
Notes/MSP-TableValueFunctions.sql
Notes/Notes.txt
Sprocs/MSPCopyFile.vb
Sprocs/MSPDeleteFile.vb
Sprocs/MSPDeleteFiles.vb
Sprocs/MSPGetFileSpecs.vb
Sprocs/MSPMakeDirectory.vb
Sprocs/MSPMoveFile.vb
Sprocs/MSPSaveFileImage.vb
SupportingObjects/SharedObjects.vb
SupportingObjects/ShowError.vb
Test Scripts/Test.sql
Download
Click the following link to download nclsqlclrfile.zip.
nclsqlclrfile.zip