-
Notifications
You must be signed in to change notification settings - Fork 1
/
Regex.sql
128 lines (126 loc) · 9.68 KB
/
Regex.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
CREATE ASSEMBLY [SqlServerUdf] FROM
0x4D5A90000300000004000000FFFF0000B80000000000000040000000000000000000000000000000\
0000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD215468\
69732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A\
2400000000000000504500004C01030007229D5C0000000000000000E00022200B013000000A0000\
00060000000000001629000000200000004000000000001000200000000200000400000000000000\
060000000000000000800000000200008D8E00000300608500001000001000000000100000100000\
00000000100000000000000000000000C42800004F00000000400000B80200000000000000000000\
0000000000000000006000000C0000008C2700001C00000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000200000080000000000000000000000\
082000004800000000000000000000002E746578740000001C09000000200000000A000000020000\
000000000000000000000000200000602E72737263000000B80200000040000000040000000C0000\
000000000000000000000000400000402E72656C6F6300000C000000006000000002000000100000\
0000000000000000000000004000004200000000000000000000000000000000F828000000000000\
480000000200050014210000F8050000090000000000000000000000000000000C27000080000000\
0000000000000000000000000000000000000000000000000000000000000000133006005F000000\
000000000F00280500000A2C067E0600000A2A0F01280500000A2C0C7201000070280700000A1001\
02280800000A03280800000A0F02280900000A2D090F02280A00000A2B011616161F0A730B00000A\
280C00000A2D067E0D00000A2A7E0E00000A2A001330040044000000000000000F00280500000A2D\
090F01280500000A2C02022A02280800000A03280800000A04280800000A0F03280900000A2D090F\
03280A00000A2B0116280F00000A280700000A2A1E02281000000A2A42534A420100010000000000\
0C00000076342E302E33303331390000000005006C000000D0010000237E00003C02000000020000\
23537472696E6773000000003C040000040000002355530040040000100000002347554944000000\
50040000A801000023426C6F620000000000000002000001471500000900000000FA013300160000\
010000000C000000020000000300000007000000100000000500000001000000030000000000DD00\
01000000000006006400500106008400500106003B003D010F00700100000600C801F9000A004F00\
1C010A0000017F010A00C6007F010A0001007F0106000B01F9000E00F80194010E00B30194010000\
00000A00000000000100010001001000BE00B1001500010001005020000000009600D000ED000100\
BC200000000096002800F80004000C2100000000861837010600080000000100F301000002001401\
00000300C00100000100F30100000200140100000300E70100000400C00109003701010011003701\
0600190037010A003100370106004100EE0010003900F40014004100CF0118004100DB011E004900\
EE0010004900A20024005100370128005900D5002F003900350014003900AC00140059002D003900\
2900370106002000230036012E000B0005012E0013000E012E001B002D01400023006F0104800000\
0000000000000000010000004B00B100000004000000000000000000000042001F00000000000400\
0000000000000000000042001300000000000400000000000000000000004200F900000000000000\
0053716C496E743332003C4D6F64756C653E0053797374656D2E44617461006D73636F726C696200\
52656765785265706C6163650046616C73650044656275676761626C654174747269627574650053\
716C46756E6374696F6E41747472696275746500436F6D70696C6174696F6E52656C61786174696F\
6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574\
65006765745F56616C756500547275650053716C5365727665725564660054657874556466005371\
6C537472696E6700526567657849734D617463680053716C5365727665725564662E646C6C006765\
745F49734E756C6C0053797374656D0053716C426F6F6C65616E0054696D655370616E0070617474\
65726E004D6963726F736F66742E53716C5365727665722E536572766572002E63746F7200537973\
74656D2E446961676E6F73746963730053797374656D2E52756E74696D652E436F6D70696C657253\
6572766963657300446562756767696E674D6F6465730053797374656D2E446174612E53716C5479\
7065730053797374656D2E546578742E526567756C617245787072657373696F6E73005265676578\
4F7074696F6E73006F7074696F6E73004F626A656374006F705F496D706C69636974006F705F4578\
706C69636974007265706C6163656D656E74007465787400526567657800000000010000AF540A56\
BC1A03438B58900DDF02FAF100042001010803200001052001011111032000020306111D05000111\
210E0500010E11210320000806200301080808090004020E0E113111290800040E0E0E0E113108B7\
7A5C561934E08980A000240000048000009400000006020000002400005253413100040000010001\
007D6BDDE17AF456BD3F95F02A3AB4BF2DE9EE06DB00C5AE9B3A526994783E11D0C6BB90B1260CEC\
5391FE5F81344B5EB379A7E21A04A16E5FABD06C98BFDFE4C4E042B95241C8B2351D90E4D0764319\
0C9874610BDE9C452B19E13808AF00EB6164FB0C798639CA0CDA3737618102DF5206B696E078C1E6\
A629B500D65C2F73C60A0003111D1121112111250C00041121112111211121112508010008000000\
00001E01000100540216577261704E6F6E457863657074696F6E5468726F77730108010002000000\
00003801000300540E044E616D650C526567657849734D6174636854020F497344657465726D696E\
697374696301540209497350726563697365013801000300540E044E616D650C5265676578526570\
6C61636554020F497344657465726D696E69737469630154020949735072656369736501623E3EDD\
8F56D8F3ECE77790F56C4F1771EA610D263E7A2287D206CAE2C2CA22339B64589D9769031B5CAF2D\
C77F912E6FA891B324EBA3CF968A879D5B214BF6A5927FAD467B02E87C661BEDBAE6101C586D7328\
5EA18857DCDCF470E33D777A76C68854611E52392FD099C8A35025D6CC1254F1287BD8215BDB0002\
53837C8B0000000007229D5C00000000020000001C010000A8270000A80900005253445316BDD720\
C2AB884698C75EF43059767501000000443A5C50726F6A656374735C436F726532305C546573745C\
53716C436C725C53716C5365727665725564665C6F626A5C52656C656173655C53716C5365727665\
725564662E7064620000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
000000000000000000000000000000000000000000000000000000000000000000000000EC280000\
000000000000000006290000002000000000000000000000000000000000000000000000F8280000\
000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25\
00200010000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000001001000000018000080000000000000000000000000000001000100000030000080\
000000000000000000000000000001000000000048000000584000005C0200000000000000000000\
5C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000\
BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000\
000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00\
000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004\
BC010000010053007400720069006E006700460069006C00650049006E0066006F00000098010000\
01003000300030003000300034006200300000002C0002000100460069006C006500440065007300\
6300720069007000740069006F006E000000000020000000300008000100460069006C0065005600\
65007200730069006F006E000000000030002E0030002E0030002E00300000004200110001004900\
6E007400650072006E0061006C004E0061006D0065000000530071006C0053006500720076006500\
72005500640066002E0064006C006C00000000002800020001004C006500670061006C0043006F00\
70007900720069006700680074000000200000004A00110001004F0072006900670069006E006100\
6C00460069006C0065006E0061006D0065000000530071006C005300650072007600650072005500\
640066002E0064006C006C0000000000340008000100500072006F00640075006300740056006500\
7200730069006F006E00000030002E0030002E0030002E0030000000380008000100410073007300\
65006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E00\
30000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000002000000C00000018390000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
00000000000000000000000000000000000000000000000000000000000000000000000000000000\
0000000000000000;
GO
CREATE FUNCTION RegexIsMatch(@text NVARCHAR(MAX) NULL, @pattern NVARCHAR(MAX) NOT NULL, @options INT NULL)
RETURNS BIT
AS EXTERNAL NAME [SqlServerUdf].[SqlServerUdf.TextUdf].[RegexIsMatch];
GO
CREATE FUNCTION RegexReplace(@text NVARCHAR(MAX) NULL, @pattern NVARCHAR(MAX) NOT NULL, @replacement NVARCHAR(MAX), @options INT NULL)
RETURNS NVARCHAR(MAX)
AS EXTERNAL NAME [SqlServerUdf].[SqlServerUdf.TextUdf].[RegexReplace];
GO