Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.