MS-SQL CLR extension function package CLR_FunctionS!
CLR_FunctionS includes a series of SQL-Server CLR extension functions
To extend the MS-SQL function
There are: file operation, directory operation, data conversion, Chinese phonetic code, and, of course, string decomposition and aggregation functions.
For details, please see the attached help document: CLR_FunctionS.CHM
If you have any comments or suggestions, please come to my blog to leave a message! Http://4721988.blog.51cto.com
Lifox 2016-04-21
Scalar function Dir_Exist: check whether [directory] exists
Scalar function Dir_FullName: returns the full path of the directory without verifying the existence of the directory
Scalar function Dir_New: create a new directory
Scalar function Dir_Del: delete a directory
Scalar function Dir_Move: move directories
Scalar function Dir_ReName: directory renaming
Table-valued function Dir_Find: finds subdirectories under a specified directory
:
Scalar function File_Exist: check whether [file] exists
Scalar function File_FullName: returns [full path file name] without verifying the existence of the file.
Scalar function File_CanRead: check whether [file] is readable
Scalar function File_Size: returns the file [length] bytes
Scalar function File_Copy: copying files
Scalar function File_Del: delete files
Scalar function File_Move: moving files
Scalar function File_ReName: file renaming
Table-valued function File_Find: finds files in a specified directory
Scalar function File_Put: generate [file] with variable length binary data [VarBinary]
Scalar function File_Get: read [file] into [VarBinary] variable length binary data
:
Scalar function BinToStr16: [VarBinary] is converted to [hexadecimal text]
Scalar function Str16ToBin: [hexadecimal text] converted to [VarBinary]
Aggregate function Str_Join: string aggregation
Aggregate function Str_JoinAsInt: integer aggregation
Table-valued function Str_Split: string decomposition
Table-valued function Str_SplitToInt: integer string decomposition
:
Scalar function Path_FileName: extract [file name] from [path string]. Do not verify that the path actually exists!
Scalar function Path_ExtensionName: extract [extension] from [path string]. Do not verify that the path actually exists!
Scalar function Path_Directory: extract [directory name] from [path string]. Do not verify that the path actually exists!
:
Scalar function HZ_isHZ: judge whether a character is a Chinese character according to the Chinese character table
Scalar function HZ_Py: [Chinese character] conversion [Pinyin code]. Support for simplified and traditional Chinese characters.
Scalar function HZ_PyD: [Chinese character] conversion [pinyin code], multi-tone word output multi-letter combination. Support for simplified and traditional Chinese characters.
Scalar function HZ_FtoJ: simplified traditional string conversion
Scalar function HZ_JtoF: simplified string conversion traditional
Attachment: DLL file, VB.net source code, help documentation
Attachment: http://down.51cto.com/data/2367625
