SQL Sharp 简介

SQL Sharp简介

SQL Sharp是一个基于SQL CLR开发的组件包，该组件包提供了

对SQL Server日期函数、字符串处理函数和数学函数的丰富扩

充。除此之外，该组件包还提供了正则表达式函数，Internet相

关函数（包括文件下载），压缩解压函数，文件操作函数，编码

转换函数，操作系统相关函数和Twitter访问函数。这些函数能

让我们在SQL语句中如同在dot Net和Java中一样轻松自如的处

理各种字符串和文件的处理，是T-SQL编程不可多得助手。

SQL Sharp手册目录：

Regular Expressions (RegEx) 7
RegEx_CaptureGroup 10
RegEx_Escape 10
RegEx_Index 10
RegEx_IsMatch 11
RegEx_Match 11
RegEx_Matches 12
RegEx_MatchLength 12
RegEx_MatchSimple 13
RegEx_Replace 13
RegEx_Split 13
RegEx_Unescape 14

Strings 15
String_Contains 15
String_Count 15
String_Cut 16
String_EndsWith 16
String_Equals 17
String_IndexOf 17
String_InitCap 18
String_IsNumeric 18
String_Join 20
String_LastIndexOf 20
String_Newline 21
String_NthIndexOf 21
String_PadLeft 22
String_PadRight 22
String_Replace 23
String_Split 23
String_SplitIntoFields 24
String_SplitKeyValuePairs (Not available in Free version) 25
String_StartsWith 26
String_Trim 27
String_TrimChars (Not available in Free version) 27
String_TrimEnd (Not available in Free version) 27
String_TrimStart (Not available in Free version) 27
String_WordWrap 28
Math 29
Math_CompoundAmortizationSchedule 29
Math_Constant 30
Math_Convert 30
Math_Cosh 31
Math_CubeRoot 31
Math_Factorial 32
Math_IEEERemainder (Not available in Free version) 32
Math_IsPrime 33
Math_NthRoot (Not available in Free version) 33
Math_RandomRange 33
Math_Sinh 34
Math_Tanh 35
Math_Truncate 35

InterNet 36
INET_AddressToNumber 36
INET_DownloadFile (Not available in Free version) 36
INET_FTPDo (Not available in Free version) 37
INET_FTPGet (Not available in Free version) 37
INET_FTPGetBinary (Not available in Free version) 38
INET_FTPGetFile (Not available in Free version) 39
INET_FTPPut (Not available in Free version) 39
INET_FTPPutBinary (Not available in Free version) 40
INET_FTPPutFile (Not available in Free version) 40
INET_GetHostName (Not available in Free version) 41
INET_GetIPAddress (Not available in Free version) 41
INET_GetWebPages (Not available in Free version) 41
INET_HTMLDecode 43
INET_HTMLEncode 43
INET_IsValidIPAddress 44
INET_NumberToAddress 44
INET_Ping (Not available in Free version) 44
INET_PingTime (Not available in Free version) 45
INET_SplitIntoFields (Not available in Free version) 45
INET_URIDecode 46
INET_URIEncode 47
INET_URIEncodeData 47
INET_URIGetInfo 47
INET_URIGetLeftPart 48

Miscellaneous 49
Util_CRC32 49
Util_Deflate 49
Util_GenerateDateTimeRange 49
Util_GenerateDateTimes 50
Util_GenerateFloatRange 50
Util_GenerateFloats 51
Util_GenerateIntRange 51
Util_GenerateInts 51
Util_GUnzip 52
Util_GZip 52
Util_Hash 52
Util_HashBinary 53
Util_Inflate 53
Util_IsValidCC 53
Util_IsValidCheckRoutingNumber 54
Util_IsValidConvert 54
Util_IsValidPostalCode 55
Util_IsValidSSN 56
Util_ToWords 56

Date 58
Date_Age 58
Date_BusinessDays 58
Date_DaysInMonth 60
Date_DaysLeftInYear 61
Date_Extract 61
Date_FormatTimeSpan 62
Date_FirstDayOfMonth 64
Date_FromUNIXTime 64
Date_FullDateString 64
Date_FullDateTimeString (not available in Free version) 65
Date_FullTimeString 65
Date_GetDateTimeFromIntVals 65
Date_GetIntDate 66
Date_GetIntTime 66
Date_IsBusinessDay 66
Date_IsLeapYear 67
Date_LastDayOfMonth 67
Date_NewDateTime 68
Date_NthOccurrenceOfWeekday 68
Date_ToUNIXTime 68
Date_Truncate 68

Internal 70
SQLsharp_GrantPermissions 70
SQLsharp_Help 70
SQLsharp_IsUpdateAvailable 70
SQLsharp_SetSecurity 70
SQLsharp_Setup 71
SQLsharp_Uninstall 71
SQLsharp_Update (Not available in Free version) – not currently working 71
SQLsharp_Version() 71
SQLsharp_WebSite() 71

File (Not available in Free version) 72
File_ChangeEncoding 72
File_Copy 72
File_CopyMultiple 73
File_CreateDirectory 74
File_CreateTempFile 74
File_CurrentEncoding 74
File_Decrypt 75
File_Delete 75
File_DeleteDirectory 76
File_DeleteMultiple 76
File_Encrypt 77
File_GetDirectoryListing 77
File_GetDirectoryName 78
File_GetDriveInfo 78
File_GetFile 78
File_GetFileBinary 79
File_GetFileInfo 79
File_GetFileName 79
File_GetRandomFileName 80
File_GetRootDirectory 80
File_GetTempPath 80
File_GUnzip 81
File_GZip 81
File_Move 81
File_MoveMultiple 82
File_PathExists 83
File_SplitIntoFields 83
File_Touch 84
File_WriteFile 85
File_WriteFileBinary 86

Database 88
DB_BulkCopy 88
DB_BulkExport 89
DB_DumpData (Not available in Free version) 91
DB_ForEach 95
DB_HTMLExport 97
DB_XOR 101

Convert 103
Convert_BinaryToHexString 103
Convert_DateTimeToMSIntDate 103
Convert_FromBase64 103
Convert_HexStringToBinary 103
Convert_HtmlToXml 104
Convert_MSIntDateToDateTime 105
Convert_ROT13 105
Convert_ToBase64 105
Convert_UUDecode 106
Convert_UUEncode 106

DB System Info (Not available in Free version) 107
Sys_Objects 107

LookUp 108
LookUp_GetCountryInfo 108
LookUp_GetStateInfo 108

Operating System 110
OS_EventLogRead 110
OS_EventLogWrite 111
OS_GenerateTone 112
OS_MachineName 112
OS_ProcessGetInfo (Not available in Free version) 113
OS_ProcessKill (Not available in Free version) 113
OS_ProcessStart (Not available in Free version) 114
OS_StartTime 114
OS_Uptime 114

Twitter 116
Twitter_BlockUser 116
Twitter_CreateFavorite 116
Twitter_DestroyDirectMessage 117
Twitter_DestroyFavorite 117
Twitter_DestroyStatus 117
Twitter_FollowUser 118
Twitter_GetBlocks 118
Twitter_GetFavorites 118
Twitter_GetFollowers 119
Twitter_GetFriends 119
Twitter_GetFriendsTimeline 119
Twitter_GetHomeTimeline 120
Twitter_GetMentions 120
Twitter_GetMessages 121
Twitter_GetPublicTimeline 122
Twitter_GetReplies (deprecated) 122
Twitter_GetRetweetedBy 122
Twitter_GetRetweetedByMe 123
Twitter_GetRetweetedToMe 123
Twitter_GetRetweets 124
Twitter_GetRetweetsOfMe 124
Twitter_GetSentMessages 125
Twitter_GetStatus 125
Twitter_GetUser 126
Twitter_GetUserTimeline 126
Twitter_Retweet 127
Twitter_SendDirectMessage 127
Twitter_UnFollowUser 128
Twitter_UnBlockUser 128
Twitter_Update 128
Twitter_xAuth 129

Running Totals (Not available in Free version) 130
RunningTotal_Add 130
RunningTotal_CacheSize 131
RunningTotal_ClearCache 131
RunningTotal_Get 131

User-Defined Aggregates 133
Agg_GeometricAvg 133
Agg_Join 133
Agg_Median 134
Agg_Random 134
Agg_RootMeanSqr 135

User-Defined Types 136
Type_FloatArray 136
Type_HashTable 140
Type_NVarcharArray