SQL sharp Introduction

SQL sharp Introduction

SQL Sharp is a component package developed based on SQL CLR, which provides

Extensive expansion of SQL Server date functions, string processing functions, and mathematical functions

. In addition, the package also provides regular expression functions

Off function (including File Download), compression and decompression function, file operation function, encoding

Conversion functions, operating system functions, and Twitter access functions. These functions can

In SQL statements, it is as easy as dot net and Java.

Processing of various strings and files is a rare assistant in T-SQL programming.

SQL sharp manual directory:

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_split1_fields 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_split1_fields (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_split1_fields 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_datetimetomsindate 103
Convert_frombase64 (103)
Convert_hexstringtobinary 103
Convert_htmltoxml 104
Convert_msintdatetodatetime105
Convert_rot13 105
Convert_tobase64, 105
Convert_uudecodes 106
Convert_uuencodes 106

DB system info (not available in free version) 107
Sys_objective 107

Lookup 108
Lookup_getcountryinfo 108
Lookup_getstateinfo 108

Operating System 110
OS _eventlogread 110.
OS _eventlog write 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_getmessage 121
Twitter_getpublictimeline 122
Twitter_getreplies (Deprecated) 122
Twitter_getretweetedby 122
Twitter_getretweetedbyme 123
Twitter_getretweetedtome 123
Twitter_getretweets 124
Twitter_getretweetsofme 124
Twitter_getsentmessage 125
Twitter_getstatus 125
Twtter_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_1_ache 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