CLR实用函数：正则、字符串聚合 --转载

写了四个CLR函数，我们比较常用的功能

自定义函数

REGULARMATCH()对应C#中MATCH

IS_REGULARMATCH()对应C#中IS_MATCH

自定义聚合

STR_SUM字符串聚合，中间半角逗号分隔

STR_UNION_SUM字符串去重聚合，也是半角逗号分隔

使用示例：

 1 USE MASTER
 2 GO
 3 
 4 
 5 --判断手机号是否合法
 6 SELECT dbo.IS_REGULARMATCH('13888888888','^(1[3,5,8,4][0-9])\d{8}$'),dbo.IS_REGULARMATCH('123456789','^(1[3,5,8,4][0-9])\d{8}$')
 7 --1    0
 8 
 9 --聚合函数使用示例
10 IF OBJECT_ID('TB') IS NOT NULL DROP TABLE TB
11 GO
12 CREATE TABLE TB(
13 ID INT
14 ,VAL VARCHAR(MAX)
15 )
16 GO
17 INSERT INTO TB
18 SELECT 1,'AA' UNION ALL
19 SELECT 2,'B' UNION ALL
20 SELECT 3,'CD'
21 GO 
22 INSERT INTO TB
23 SELECT 1,'AA' UNION ALL
24 SELECT 2,'BB' UNION ALL
25 SELECT 3,'CD'
26 GO
27 SELECT ID,DBO.STR_SUM(VAL),DBO.STR_UNION_SUM(VAL)
28 FROM TB
29 GROUP BY ID
30 /*
31 1    AA,AA    AA
32 2    BB,B    BB,B
33 3    CD,CD    CD
34 */

复制下面的代码到数据库里运行后就可以用了

 1 sp_configure 'show advanced options', 1; 
 2 GO 
 3 RECONFIGURE; 
 4 GO 
 5 sp_configure 'clr enabled', 1; 
 6 GO 
 7 RECONFIGURE; 
 8 GO
 9 
10 CREATE ASSEMBLY [SqlServerProject1]
11     AUTHORIZATION [dbo]
12     FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300200F61510000000000000000E00002210B010800001000000006000000000000FE2E0000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000AC2E00004F000000004000007803000000000000000000000000000000000000006000000C000000282E00001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000040F0000002000000010000000020000000000000000000000000000200000602E7273726300000078030000004000000004000000120000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001600000000000000000000000000004000004200000000000000000000000000000000E02E000000000000480000000200050060230000C80A0000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013300200500000000100001100027E0F00000A281000000A281100000A16FE010C082D087E0F00000A0A2B2A0F00FE16040000016F1200000A0F01FE16040000016F1200000A281300000A6F1400000A281500000A0A060B2B00072A133002004C0000000200001100027E0F00000A281000000A281100000A16FE010C082D0916281600000A0A2B250F00FE16040000016F1200000A0F01FE16040000016F1200000A281700000A281600000A0A060B2B00072A1E02281800000A2A4A00027201000070731C00000A7D010000042A00133003004300000003000011000F01281D00000A0A062D36027B01000004027B010000046F1E00000A16300772010000702B057203000070281500000A03281F00000A8C040000016F2000000A262A4200020F0128070000062805000006002A13300100160000000400001100027B010000046F1200000A281500000A0A2B00062A4E0002036F2100000A731C00000A7D010000042A0000133004004F0000000300001100027B010000046F1E00000A20A00F0000FE0216FE010A062D22027B0100000420A00F0000027B010000046F1E00000A20A00F0000596F2200000A2603027B010000046F1200000A6F2300000A002A4A00027201000070731C00000A7D020000042A0000133004008300000003000011007203000070027B020000046F1200000A7203000070282400000A72030000700F01FE16040000016F1200000A7203000070282400000A6F2500000A2D090F01281D00000A2B01170A062D36027B02000004027B020000046F1E00000A16300772010000702B057203000070281500000A03281F00000A8C040000016F2000000A262A4200020F01280D000006280B000006002A13300100160000000400001100027B020000046F1200000A281500000A0A2B00062A4E0002036F2100000A731C00000A7D020000042A000013300400510000000300001100027B020000046F1E00000A20A00F0000FE0216FE010A062D2400027B0200000420A00F0000027B020000046F1E00000A20A00F0000596F2200000A260003027B020000046F1200000A6F2300000A002A00000042534A4201000100000000000C00000076322E302E35303732370000000005006C0000000C040000237E000078040000A004000023537472696E67730000000018090000080000002355530020090000100000002347554944000000300900009801000023426C6F620000000000000002000001571702000900000000FA253300160000010000002000000004000000020000000F0000000C00000002000000250000000F00000004000000010000000300000000000A0001000000000006005B0054000600620054000A00930078000A00B900A4000A00D000A4000600FD00F100060038012E0106004A012E010600A0018E010600B7018E010600D4018E010600F3018E0106000C028E01060025028E01060040028E0106005B028E010600930274020600A7028E010600D302C0024F00E702000006001603F60206003603F6020A00660378000E00BC039D030E00C2039D030E00C8039D030600EE0354000A00040478000A002504780006002C047402060042047402060088045400000000000100000000000100010001001000200000000500010001000921100035000000090001000400092110003D000000090002000A0001000B01200001000B0120005020000000009600C3000A000100AC20000000009600DB00130003000421000000008618EB001C0005000C210000000086000E011C00050020210000000086001301240005006F210000000086001E012A0006008021000000008600240130000700A22100000000E601450135000700B82100000000E60157013B00080013220000000086000E011C0009002822000000008600130124000900B7220000000086001E0141000A00C822000000008600240130000B00EA2200000000E601450135000B00002300000000E60157013B000C00000001005D01000002006801000001005D01000002007401000001007E01000001008401000001008A01000001008C01000001007E01000001008401000001008A01000001008C0103000D0004000D004900EB0047005100EB0047005900EB0047006100EB0047006900EB0047007100EB0047007900EB0047008100EB0047008900EB004C009100EB0047009900EB005100A900EB005700B100EB001C00B900EB001C0021007B03610021008003130029008C036500090094036B00C100C2036F00D100D0036B002100DA0376002900DA038400C100E6038A000900EB001C00D900EB001C00E100EB009800F100EB0000013100EB00470021004D040601310058040A01210063040A0031006F040E01390076046B00310081041D0141005701470001018F042401010196042B01200073005C002E00230047012E002B0030012E0063006E012E000B0030012E00130047012E001B0047012E006B0077012E0033004D012E003B0047012E004B0047012E005B006501400073005C006300D3009E008300D3009E007C009000140118010480000001000000ED1250640000000000005403000002000000000000000000000001004B000000000002000000000000000000000001006C000000000002000000000000000000000001005400000000000000003C4D6F64756C653E0053716C53657276657250726F6A656374312E646C6C0055736572446566696E656446756E6374696F6E73005354525F53554D005354525F554E494F4E5F53554D006D73636F726C69620053797374656D004F626A6563740056616C7565547970650053797374656D2E44617461004D6963726F736F66742E53716C5365727665722E536572766572004942696E61727953657269616C697A650053797374656D2E446174612E53716C54797065730053716C537472696E6700524547554C41524D415443480053716C426F6F6C65616E0049535F524547554C41524D41544348002E63746F720053797374656D2E5465787400537472696E674275696C64657200736200496E697400416363756D756C617465004D65726765005465726D696E6174650053797374656D2E494F0042696E61727952656164657200526561640042696E617279577269746572005772697465007374725F536F75726365007374725F526567756C6172007374725F52656765780056616C75650047726F7570007200770053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C747572654174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7956657273696F6E4174747269627574650053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053716C53657276657250726F6A656374310053716C46756E6374696F6E417474726962757465004E756C6C006F705F457175616C697479006F705F5472756500546F537472696E670053797374656D2E546578742E526567756C617245787072657373696F6E73005265676578004D617463680043617074757265006765745F56616C7565006F705F496D706C696369740049734D617463680053657269616C697A61626C654174747269627574650053716C55736572446566696E656441676772656761746541747472696275746500466F726D6174005374727563744C61796F7574417474726962757465004C61796F75744B696E64006765745F49734E756C6C006765745F4C656E677468006F705F4164646974696F6E00417070656E640052656164537472696E670052656D6F766500537472696E6700436F6E63617400436F6E7461696E730000000100032C000000EE849E01C5789C4888ECA36288EAD5CF0008B77A5C561934E089080002111111111111080002111511111111032000010306121905200101111105200101110C042000111105200101121D052001011221052001011110042001010E042001010205200101115104200101080401000000030611110500010211150320000E06000212650E0E05000111110E0707031111111102050001111502050002020E0E07070311151115020520010111756101000200000004005402174973496E76617269616E74546F4475706C696361746573005402124973496E76617269616E74546F4E756C6C73015402124973496E76617269616E74546F4F726465720054080B4D61784279746553697A65401F000005200101117D032000020320000805200112191C030701020407011111062002121908080600030E0E0E0E042001020E1601001153716C53657276657250726F6A65637431000005010000000017010012436F7079726967687420C2A920203230313300000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301000000000000200F6151000000000200000068000000442E00004410000052534453A7568C7938BA12408B5091FB64FF61260B000000443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C6F626A5C44656275675C53716C53657276657250726F6A656374312E70646200D42E00000000000000000000EE2E0000002000000000000000000000000000000000000000000000E02E0000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000200300000000000000000000200334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001005064ED12000001005064ED123F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00480020000010053007400720069006E006700460069006C00650049006E0066006F0000005C02000001003000300030003000300034006200300000004C0012000100460069006C0065004400650073006300720069007000740069006F006E0000000000530071006C00530065007200760065007200500072006F006A006500630074003100000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0034003800340035002E0032003500360038003000000000004C001600010049006E007400650072006E0061006C004E0061006D0065000000530071006C00530065007200760065007200500072006F006A0065006300740031002E0064006C006C0000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020002000320030003100330000005400160001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C00530065007200760065007200500072006F006A0065006300740031002E0064006C006C000000440012000100500072006F0064007500630074004E0061006D00650000000000530071006C00530065007200760065007200500072006F006A006500630074003100000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0034003800340035002E00320035003600380030000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0034003800340035002E00320035003600380030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000003F00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
13     WITH PERMISSION_SET = SAFE;
14 GO
15 ALTER ASSEMBLY [SqlServerProject1]
16     DROP FILE ALL
17     ADD FILE FROM 0xEFBBBF7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174613B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A7573696E672053797374656D2E546578742E526567756C617245787072657373696F6E733B0D0A0D0A7075626C6963207061727469616C20636C6173732055736572446566696E656446756E6374696F6E730D0A7B0D0A202020205B4D6963726F736F66742E53716C5365727665722E5365727665722E53716C46756E6374696F6E5D0D0A202020207075626C6963207374617469632053716C537472696E6720524547554C41524D415443482853716C537472696E67207374725F536F757263652C53716C537472696E67207374725F526567756C6172290D0A202020207B0D0A202020202020202053716C537472696E6720693B0D0A2020202020202020696620287374725F536F75726365203D3D2053716C537472696E672E4E756C6C290D0A20202020202020202020202069203D2053716C537472696E672E4E756C6C3B0D0A2020202020202020656C73650D0A20202020202020202020202069203D2052656765782E4D61746368287374725F536F757263652E546F537472696E6728292C207374725F526567756C61722E546F537472696E672829292E56616C75653B0D0A0D0A202020202020202072657475726E20693B0D0A202020207D0D0A7D3B0D0A0D0A AS N'REGULARMATCH.cs', 0xEFBBBF7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174613B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A7573696E672053797374656D2E546578742E526567756C617245787072657373696F6E733B0D0A0D0A7075626C6963207061727469616C20636C6173732055736572446566696E656446756E6374696F6E730D0A7B0D0A202020205B4D6963726F736F66742E53716C5365727665722E5365727665722E53716C46756E6374696F6E5D0D0A202020207075626C6963207374617469632053716C426F6F6C65616E2049535F524547554C41524D415443482853716C537472696E67207374725F536F757263652C53716C537472696E67207374725F5265676578290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A202020202020202053716C426F6F6C65616E20623B0D0A2020202020202020696620287374725F536F75726365203D3D2053716C537472696E672E4E756C6C290D0A20202020202020202020202062203D2066616C73653B0D0A2020202020202020656C73650D0A20202020202020202020202062203D2052656765782E49734D61746368287374725F536F757263652E546F537472696E6728292C207374725F52656765782E546F537472696E672829293B0D0A0D0A202020202020202072657475726E20623B0D0A202020207D0D0A7D3B0D0A0D0A AS N'IS_REGULARMATCH.cs', 0xEFBBBF7573696E672053797374656D2E5265666C656374696F6E3B0D0A7573696E672053797374656D2E52756E74696D652E436F6D70696C657253657276696365733B0D0A7573696E672053797374656D2E52756E74696D652E496E7465726F7053657276696365733B0D0A7573696E672053797374656D2E446174612E53716C3B0D0A0D0A2F2F2047656E6572616C20496E666F726D6174696F6E2061626F757420616E20617373656D626C7920697320636F6E74726F6C6C6564207468726F7567682074686520666F6C6C6F77696E670D0A2F2F20736574206F6620617474726962757465732E204368616E6765207468657365206174747269627574652076616C75657320746F206D6F646966792074686520696E666F726D6174696F6E0D0A2F2F206173736F636961746564207769746820616E20617373656D626C792E0D0A5B617373656D626C793A20417373656D626C795469746C65282253716C53657276657250726F6A6563743122295D0D0A5B617373656D626C793A20417373656D626C794465736372697074696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6E66696775726174696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6D70616E79282222295D0D0A5B617373656D626C793A20417373656D626C7950726F64756374282253716C53657276657250726F6A6563743122295D0D0A5B617373656D626C793A20417373656D626C79436F707972696768742822436F7079726967687420C2A920203230313322295D0D0A5B617373656D626C793A20417373656D626C7954726164656D61726B282222295D0D0A5B617373656D626C793A20417373656D626C7943756C74757265282222295D0D0A0D0A5B617373656D626C793A20436F6D56697369626C652866616C7365295D0D0A0D0A2F2F0D0A2F2F2056657273696F6E20696E666F726D6174696F6E20666F7220616E20617373656D626C7920636F6E7369737473206F662074686520666F6C6C6F77696E6720666F75722076616C7565733A0D0A2F2F0D0A2F2F2020202020204D616A6F722056657273696F6E0D0A2F2F2020202020204D696E6F722056657273696F6E0D0A2F2F2020202020204275696C64204E756D6265720D0A2F2F2020202020205265766973696F6E0D0A2F2F0D0A2F2F20596F752063616E207370656369667920616C6C207468652076616C756573206F7220796F752063616E2064656661756C7420746865205265766973696F6E20616E64204275696C64204E756D626572730D0A2F2F206279207573696E672074686520272A272061732073686F776E2062656C6F773A0D0A5B617373656D626C793A20417373656D626C7956657273696F6E2822312E302E2A22295D0D0A0D0A AS N'Properties\AssemblyInfo.cs', 0xEFBBBF7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174613B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A7573696E672053797374656D2E546578743B0D0A0D0A0D0A5B53657269616C697A61626C655D0D0A5B4D6963726F736F66742E53716C5365727665722E5365727665722E53716C55736572446566696E6564416767726567617465280D0A20202020466F726D61742E55736572446566696E65642C0D0A202020204973496E76617269616E74546F4475706C696361746573203D2066616C73652C0D0A202020204973496E76617269616E74546F4E756C6C73203D20747275652C0D0A202020204973496E76617269616E74546F4F72646572203D2066616C73652C0D0A202020204D61784279746553697A65203D20383030300D0A20202020295D0D0A7075626C696320737472756374205354525F53554D203A204942696E61727953657269616C697A650D0A7B0D0A20202020537472696E674275696C6465722073623B0D0A202020207075626C696320766F696420496E697428290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A20202020202020207362203D206E657720537472696E674275696C646572282222293B0D0A202020207D0D0A0D0A202020207075626C696320766F696420416363756D756C6174652853716C537472696E672056616C7565290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A0D0A2020202020202020696620282156616C75652E49734E756C6C290D0A20202020202020202020202073622E417070656E64282873622E4C656E677468203E2030203F20222C22203A20222229202B2056616C7565293B0D0A202020207D0D0A0D0A202020207075626C696320766F6964204D65726765285354525F53554D2047726F7570290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A2020202020202020416363756D756C6174652847726F75702E5465726D696E6174652829293B0D0A202020207D0D0A0D0A202020207075626C69632053716C537472696E67205465726D696E61746528290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A0D0A20202020202020202F2F6966202873622E4C656E677468203E2034303030290D0A20202020202020202F2F2020202073622E52656D6F766528343030302C2073622E4C656E677468202D2034303030293B0D0A202020202020202072657475726E2073622E546F537472696E6728293B0D0A202020207D0D0A0D0A0D0A0D0A202020207075626C696320766F696420526561642853797374656D2E494F2E42696E6172795265616465722072290D0A202020207B0D0A20202020202020207362203D206E657720537472696E674275696C64657228722E52656164537472696E672829293B200D0A202020207D0D0A0D0A202020207075626C696320766F69642057726974652853797374656D2E494F2E42696E6172795772697465722077290D0A202020207B0D0A20202020202020206966202873622E4C656E677468203E2034303030290D0A20202020202020202020202073622E52656D6F766528343030302C2073622E4C656E677468202D2034303030293B0D0A2020202020202020772E57726974652873622E546F537472696E672829293B0D0A202020207D0D0A7D0D0A AS N'STR_SUM.cs', 0xEFBBBF7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174613B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A7573696E672053797374656D2E546578743B0D0A0D0A0D0A5B53657269616C697A61626C655D0D0A5B4D6963726F736F66742E53716C5365727665722E5365727665722E53716C55736572446566696E6564416767726567617465280D0A20202020466F726D61742E55736572446566696E65642C0D0A202020204973496E76617269616E74546F4475706C696361746573203D2066616C73652C0D0A202020204973496E76617269616E74546F4E756C6C73203D20747275652C0D0A202020204973496E76617269616E74546F4F72646572203D2066616C73652C0D0A202020204D61784279746553697A65203D20383030300D0A20202020295D0D0A7075626C696320737472756374205354525F554E494F4E5F53554D203A204942696E61727953657269616C697A650D0A7B0D0A20202020537472696E674275696C6465722073623B0D0A202020207075626C696320766F696420496E697428290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A20202020202020207362203D206E657720537472696E674275696C646572282222293B0D0A202020207D0D0A0D0A202020207075626C696320766F696420416363756D756C6174652853716C537472696E672056616C7565290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A2020202020202020696620282128222C22202B2073622E546F537472696E672829202B20222C22292E436F6E7461696E7328222C22202B2056616C75652E546F537472696E672829202B20222C2229202626202156616C75652E49734E756C6C290D0A20202020202020202020202073622E417070656E64282873622E4C656E677468203E2030203F20222C22203A20222229202B2056616C7565293B0D0A202020207D0D0A0D0A202020207075626C696320766F6964204D65726765285354525F554E494F4E5F53554D2047726F7570290D0A202020207B0D0A20202020202020202F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A2020202020202020416363756D756C6174652847726F75702E5465726D696E6174652829293B0D0A202020207D0D0A0D0A202020207075626C69632053716C537472696E67205465726D696E61746528290D0A202020207B0D0A20202020202020202F2F2F2F20E59CA8E6ADA4E5A484E694BEE7BDAEE4BBA3E7A0810D0A202020202020202072657475726E2073622E546F537472696E6728293B0D0A202020207D0D0A0D0A0D0A202020207075626C696320766F696420526561642853797374656D2E494F2E42696E6172795265616465722072290D0A202020207B0D0A20202020202020207362203D206E657720537472696E674275696C64657228722E52656164537472696E672829293B0D0A202020207D0D0A0D0A202020207075626C696320766F69642057726974652853797374656D2E494F2E42696E6172795772697465722077290D0A202020207B0D0A20202020202020206966202873622E4C656E677468203E2034303030290D0A20202020202020207B0D0A20202020202020202020202073622E52656D6F766528343030302C2073622E4C656E677468202D2034303030293B0D0A20202020202020207D0D0A2020202020202020772E57726974652873622E546F537472696E672829293B0D0A0D0A202020207D0D0A0D0A7D0D0A AS N'SUM_UNION_SUM.cs', 0x4D6963726F736F667420432F432B2B204D534620372E30300D0A1A445300000000020000020000002B000000E400000000000000270000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008041FBFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF388E040000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF0BCA3101380000000010000000100000000000001100FFFF0400000003800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000009254CECD594C0D2ED5B2BEDDE8A0A68DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF280000002700000003000000060000002300000024000000250000000C0000000D0000001300000007000000080000000E000000100000001400000015000000160000001700000018000000190000001A0000001B0000001C0000001D0000001E0000001F00000021000000200000002200000011000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A7991000000000000000BC039F8ADEA4ABEA57B36D3AAE2B65EB000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000BCA310138000000001000000010000000000000FFFFFFFF040000000380000000000000FFFFFFFF00000000FFFFFFFF00000000FFFFFFFF000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000009254CECD594C0D2ED5B2BEDDE8A0A68DFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF280000002800000003000000060000002400000025000000260000000C0000000D0000001200000004000000050000000B0000000F0000001400000015000000160000001700000018000000190000001A0000001B0000001C0000001D0000001E0000001F000000200000002200000021000000230000001100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A799100000000000000092A06A99BDC1DB5A40182DCCC98F1B78000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B000000E8000000BD01000038000000FFFFFFFF000000005802000004010000580000005800000058000000580000000700000003000000060000000C0000000D0000001200000004000000050000000B0000000F0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009000000C607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000002967FB94574931EF06E465032105E26300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000002941C19599FB29F912ECCA41764D810000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FEEFFEEF010000000002000000443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C524547554C41524D415443482E63730000643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C726567756C61726D617463682E637300443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C5354525F53554D2E637300643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C7374725F73756D2E637300443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C49535F524547554C41524D415443482E637300643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C69735F726567756C61726D617463682E637300443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C53554D5F554E494F4E5F53554D2E637300643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C73756D5F756E696F6E5F73756D2E63730011000000000000007E010000BF01000000000000410000000000000000000000000000000000000000000000000000000100000042000000F800000082000000BD0000003B0100000900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000002941C19599FB29F912ECCA41764D8100280000001BE2300188B858F958000000010000004100000042000000650000000000000000000000BD000000280000001BE23001DCFEA919580000008200000041000000BD0000006500000000000000000000003B010000280000001BE23001D8B7FF5E58000000F8000000410000003B010000650000000000000000000000BF010000280000001BE23001F41639B6580000007E01000041000000BF010000650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000008559E590CD45502E0609887CED8B5F8C120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E53657276657200120024115553797374656D2E5465787400000000020006003A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040000000C00000001000600040222000C000000010000060200060032002A1100000000800100000000000053000000000000000000000005000006AE0000000100000000416363756D756C617465002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C00000004000006020006002E002A1100000000E401000000000000100000000000000000000000060000060101000001000000004D6572676500002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C000000040000060200060032002A110000000088020000000000001600000000000000F862513FC607D311905300C04FA302A1C4454B99E9E6D211903F00C04FA302A10B9D865A1166D311BD2A0000F80849BD60A66E40CF64824CB6F042D48172A79910000000000000008BAF2DEEA818ADFC0AA5F06EC33594822E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C00000004000006020006002E002A1100000000EC0200000000000013000000000000000000000008000006270100000100000000526561640000002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C00000004000006020006002E002A11000000005003000000000000260000000000000000000000090000063A0100000100000000577269746500002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000400000602000600F20000003C0000009C0000000100010012000000000000000300000030000000000000001500008001000000170000801100000018000080050006000900240005000600F20000003C000000AE0000000100010053000000000000000300000030000000000000001B000080010000001E000080520000001F000080050006000900550005000600F20000003C0000000101000001000100100000000000000003000000300000000000000000000000000000009802000000000000980200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000600000001000000390000000000000042000000280000001BE2300188B858F958000000010000004100000042000000650000000000000000000000BD000000280000001BE2300136E53956580000008200000041000000BD0000006500000000000000000000003B010000280000001BE23001D8B7FF5E58000000F8000000410000003B010000650000000000000000000000BF010000280000001BE23001F41639B6580000007E01000041000000BF010000650000000000000000000000000000003000000000000000140000002C0000004800000060000000740000008C000000A4000000BC000000D0000000E8000000FC000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001BE2300104010000F7710F265733CE010A0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000600000001000000390000000000000042000000280000001BE2300188B858F958000000010000004100000042000000650000000000000000000000BD000000280000001BE230010CC06DC7580000008200000041000000BD0000006500000000000000000000003B010000280000001BE23001D8B7FF5E58000000F8000000410000003B010000650000000000000000000000BF010000280000001BE230012999370E580000007E01000041000000BF0100006500000000000000000000000C00000001000600040222000C000000010000060200060032002A1100000000800100000000000053000000000000000000000005000006AE0000000100000000416363756D756C617465002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C00000004000006020006002E002A1100000000E401000000000000100000000000000000000000060000060101000001000000004D6572676500002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C000000040000060200060032002A1100000000880200000000000016000000000000001BE2300104010000792DD65F5733CE010B0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000600000001000000390000000000000042000000280000001BE2300188B858F958000000010000004100000042000000650000000000000000000000BD000000280000001BE23001686C3B58580000008200000041000000BD0000006500000000000000000000003B010000280000001BE23001D8B7FF5E58000000F8000000410000003B010000650000000000000000000000BF010000280000001BE2300155CDE343580000007E01000041000000BF0100006500000000000000000000000000000000000000090000063A0100000100000000577269746500002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000400000602000600F20000003C0000009C0000000100010012000000000000000300000030000000000000001500008001000000170000801100000018000080050006000900240005000600F20000003C000000AE0000000100010053000000000000000300000030000000000000001B000080010000001E000080520000001F000080050006000900550005000600F20000003C00000001010000010001001000000000000000030000003000000000000000040000002E002A11000000001801000000000000120000000000000000000000040000069C0000000100000000496E69740000001600031104000000D8000000120000009C000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E53657276657200120024115553797374656D2E5465787400000000020006003A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040000000C00000001000600040222000C000000010000060200060032002A1100000000BC0100000000000043000000000000000000000005000006AE0000000100000000416363756D756C61746500160003111C0100008801000043000000AE000000010000001E00201100000000030000110000000000000400435324342430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C00000004000006020006002E002A1100000000200200000000000010000000000000000000000006000006F100000001000000004D6572676500002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C000000040000060200060032002A1100000000C402000000000000160000000000000000000000070000060101000001000000005465726D696E61746500001600031124020000900200001600000001010000010000001E00201100000000040000110000000000000400435324312430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C00000004000006020006002E002A1100000000280300000000000013000000000000000000000008000006170100000100000000526561640000002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C00000004000006020006002E002A1100000000C8030000000000004F0000000000000000000000090000062A010000010000000057726974650000160003112C030000940300004F0000002A010000010000001E00201100000000030000110000000000000400435324342430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000400000602000600F20000003C0000009C0000000100010012000000000000000300000030000000000000001500008001000000170000801100000018000080050006000900240005000600F200000054000000AE0000000100010043000000000000000500000048000000000000001B000080010000001E00008009000000EEEFFE800C0000001F00008042000000200000800500060009001B00000000000D003B0005000600F20000003C000000F10000000100010010000000000000000300000030000000000000002300008001000000250000800F00000026000080050006000900270005000600F20000003C0000000101000001000100160000000000000003000000300000000000000029000080010000002E000080140000002F0000800500060009001E0005000600F20000003C000000170100000100010013000000000000000300000030000000000000003400008001000000350000801200000036000080050006000900300005000600F2000000600000002A010000010001004F0000000000000006000000540000000000000039000080010000003A00008017000000EEEFFE801A0000003B0000803C0000003C0000804E0000003D0000800500060009001E00000000000D002F000900200005000600F40000000800000082000000000000003000000000000000140000002C0000004800000060000000740000008C000000A4000000BC000000D0000000E8000000FC000000F4000000080000008200000000000000300000000000000014000000040000002E002A110000000018010000000000001200000000000000000000000A000006790100000100000000496E69740000001600031104000000D80000001200000079010000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E53657276657200120024115553797374656D2E5465787400000000020006003A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040000000C00000001000600040222000C000000010000060200060032002A1100000000BC010000000000008300000000000000000000000B0000068B0100000100000000416363756D756C61746500160003111C01000088010000830000008B010000010000001E00201100000000030000110000000000000400435324342430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000A000006020006002E002A110000000020020000000000001000000000000000000000000C0000060E02000001000000004D6572676500002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000A0000060200060032002A1100000000C4020000000000001600000000000000000000000D0000061E02000001000000005465726D696E6174650000160003112402000090020000160000001E020000010000001E00201100000000040000110000000000000400435324312430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000A000006020006002E002A110000000028030000000000001300000000000000000000000E000006340200000100000000526561640000002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000A000006020006002E002A1100000000C8030000000000005100000000000000000000000F00000647020000010000000057726974650000160003112C030000940300005100000047020000010000001E00201100000000030000110000000000000400435324342430303030000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040122000C0000000A00000602000600F20000003C000000790100000100010012000000000000000300000030000000000000001500008001000000170000801100000018000080050006000900240005000600F2000000540000008B0100000100010083000000000000000500000048000000000000001B000080010000001D00008049000000EEEFFE804C0000001E000080820000001F0000800500060009006200000000000D003B0005000600F20000003C0000000E0200000100010010000000000000000300000030000000000000002200008001000000240000800F00000025000080050006000900270005000600F20000003C0000001E02000001000100160000000000000003000000300000000000000028000080010000002A000080140000002B0000800500060009001E0005000600F20000003C000000340200000100010013000000000000000300000030000000000000002F00008001000000300000801200000031000080050006000900300005000600F20000007800000047020000010001005100000000000000080000006C0000000000000034000080010000003500008017000000EEEFFE801A000000360000801B000000370000803D000000380000803E00000039000080500000003B0000800500060009001E000000000009000A000D002F0009000A000900200005000600F4000000080000007E01000000000000300000001401000028010000400100005C0100007401000088010000A0010000B8010000D0010000E4010000FC01000010020000030000000400000036002A11000000007C0100000000000050000000000000000000000001000006000000000100000000524547554C41524D415443480000001600031104000000480100005000000000000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E53657276657200220024115553797374656D2E546578742E526567756C617245787072657373696F6E73001E002011010000000100001100000000000004004353243124303030300000001E00201102000000010000110000000000000400435324342430303031000000160020110000000001000011000000000000000069000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040000000C00000001000600020006003A002A110000000008030000000000004C00000000000000000000000200000650000000010000000049535F524547554C41524D41544348000000001600031180010000C80200004C00000050000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E53657276657200220024115553797374656D2E546578742E526567756C617245787072657373696F6E73001E002011010000000200001100000000000004004353243124303030300000001E00201102000000020000110000000000000400435324342430303031000000160020110000000002000011000000000000000062000000020006003A000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004020000040000000C00000001000600040222000C0000000100000602000600F20000007800000000000000010001005000000000000000080000006C000000000000000C000080010000000E00008015000000EEEFFE80180000000F0000801E000000EEEFFE8020000000110000804A000000130000804E000000140000800500060009002A00000000000D002000000000000D0052000900120005000600F20000007800000050000000010001004C00000008000000080000006C000000000000000C000080010000000F00008015000000EEEFFE8018000000100000801F000000EEEFFE80210000001200008046000000140000804A000000150000800500060009002A00000000000D001700000000000D004C000900120005000600F4000000100000000100000000000000F8000000000000001000000028020000440200005C0200007C020000480000001600031104000000480100005000000000000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2E446174612E53716C436C69656E7400001A0024115553797374656D2E446174612E53716C54797065730000001E002411554D6963726F736F66742E53716C5365727665722E53657276657200220024115553797374656D2E546578742E526567756C617245787072657373696F6E73001E002011010000000100001100000000000004004353243124303030300000001E00201102000000010000110000000000000400435324342430303031000000160020110000000001000011000000000000000069000000020006002E000404C93FEAC6B359D649BC250902BBABB460000000004D0044003200000004010000040000000C00000001000600020006003A002A110000000008030000000000004C00000000000000000000000200000650000000010000000049535F524547554C41524D41544348000000001600031180010000C80200004C00000050000000010000000A0024115553797374656D00120024115553797374656D2E44617461000000001A0024115553797374656D2EFFFFFFFF1A092FF1E00000005C0200007D020000010000005D01000001000000890100000100000041010000010000002D000000010000004502000001000000290100000100000075000000010000001102000001000000A1010000010000008D00000001000000A5000000010000001500000001000000B9010000010000005D020000010000004900000001000000E50100000100000015010000010000000100000001000000D100000001000000FD00000001000000FD01000001000000E90000000100000075010000010000006100000001000000D101000001000000BD000000010000002902000001000000010400000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000010400000000000000000000000000000000000000000000000000000000000001040000000200000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000010400000000000000000000000000000000000000000000000000000000002001040000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000800000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C00000018000000240000003C0000004800000054000000600000006C00000084000000900000009C000000A8000000B4000000C0000000CC000000E4000000F0000000FC000000140100002C010000440100000000000001040000000000000000000000000000000000000000000000000000000000000104000000020000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000001040000000000000000000000000000000000000000000000000000000000200104000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000001200251100000000040000000200496E697400001600291100000000040000000200303630303030303400001A002511000000001C0100000200416363756D756C6174650000000016002911000000001C0100000200303630303030303500001200251100000000C001000002004D65726765001600291100000000C001000002003036303030303036000016002511000000002402000002005465726D696E617465001600291100000000240200000200303630303030303700001200251100000000C802000002005265616400001600291100000000C802000002003036303030303038000012002511000000002C030000020057726974650016002911000000002C0300000200303630303030303900001200251100000000040000000300496E697400001600291100000000040000000300303630303030306100001A002511000000001C0100000300416363756D756C6174650000000016002911000000001C0100000300303630303030306200001200251100000000C001000003004D65726765001600291100000000C001000003003036303030303063000016002511000000002402000003005465726D696E617465001600291100000000240200000300303630303030306400001200251100000000C802000003005265616400001600291100000000C80200000300303630303030306500001200251110000000000000000000000000000000000000000000000000000000FFFFFFFF1A092FF10000000000000000010000002D000000010000004502000001000000290100000100000075000000010000001102000001000000A1010000010000008D00000001000000A5000000010000001500000001000000B9010000010000005D020000010000004900000001000000E50100000100000015010000010000000100000001000000D100000001000000FD00000001000000FD01000001000000E90000000100000075010000010000006100000001000000D101000001000000BD0000000100000029020000010000000104000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000104000000000000000000000000000000000000000000000000000000000000010400000002000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000104000000000000000000000000000000000000000000000000000000000020010400000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002C030000030057726974650016002911000000002C0300000300303630303030306600001A00251100000000040000000100524547554C41524D4154434800001600291100000000040000000100303630303030303100001E0025110000000080010000010049535F524547554C41524D415443480000001600291100000000800100000100303630303030303200002402000002005465726D696E617465001600291100000000240200000200303630303030303700001200251100000000E802000002005265616400001600291100000000E802000002003036303030303038000012002511000000004C030000020057726974650016002911000000004C0300000200303630303030303900001200251100000000040000000300496E697400001600291100000000040000000300303630303030306100001A002511000000001C0100000300416363756D756C6174650000000016002911000000001C0100000300303630303030306200001200251100000000C001000003004D65726765001600291100000000C001000003003036303030303063000016002511000000002402000003005465726D696E617465001600291100000000240200000300303630303030306400001200251100000000C802000003005265616400001600291100000000C802000003003036303030303065000012002511FFFFFFFF770931010B0000000E00008A0F006F76100001000C0100008C0100002C00000020010000000000000000000016000000190000000000EEC00000000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000D000C03000000000000180100000200000020759B0D000000000000000055736572446566696E656446756E6374696F6E7300373141414145453800000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000B00CC03000000000000E40100000100000040749B0D00000000000000005354525F53554D0036364545384341420000000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000C00CC03000000000000FC0100000100000000759B0D00000000000000005354525F554E494F4E5F53554D00413437443145363600002DBA2EF10100000000000000500000000000000000000000000000000000000001000000500000004C00000000000000000000000000000000000000010000009C000000120000000000000001000000000000000000000001000000AE000000430000000000000001000000000000000000000001000000F100000010000000000000000100000000000000000000000100000001010000160000000000000001000000000000000000000001000000170100001300000000000000010000000000000000000000010000002A0100004F0000000000000001000000000000000000000001000000790100001200000000000000020000000000000000000000010000008B0100008300000000000000020000000000000000000000010000000E0200001000000000000000020000000000000000000000010000001E02000016000000000000000200000000000000000000000100000034020000130000000000000002000000000000000000000001000000470200005100000000000000020000000000000000000000020002000D01000000000100FFFFFFFF00000000980200000802000000000000FFFFFFFF00000000FFFFFFFF03000400000002000300020001000100000000004000000083000000BE000000443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C524547554C41524D415443482E637300443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C49535F524547554C41524D415443482E637300443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C5354525F53554D2E637300443A5C70726F6A656374735C53716C53657276657250726F6A656374315C53716C53657276657250726F6A656374315C53554D5F554E494F4E5F53554D2E63730000FEEFFEEF010000000100000000010000000000000000000000FFFFFFFFFFFFFFFFFFFF1B00FFFFFFFFFFFFFFFFFFFF00FFFF0000000000000000000000000D000C030000000000001801000002000000A047FA02000000000000000055736572446566696E656446756E6374696F6E7300373141414145453800000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000B00EC030000000000000802000001000000C046FA0200000000000000005354525F53554D0036364545384341420000000000000000FFFF000000000000FFFFFFFF00000000FFFF0000000000000000000000000C00E40300000000000098020000010000008047FA0200000000000000005354525F554E494F4E5F53554D00413437443145363600002DBA2EF10100000000000000500000000000000000000000000000000000000001000000500000004C00000000000000000000000000000000000000010000009C000000120000000000000001000000000000000000000001000000AE000000430000000000000001000000000000000000000001000000F10000001000000000000000010000000000000000000000010000000101000051000000000000000100000000000000000000000100000052010000942E3101BFFD5F510B000000A7568C7938BA12408B5091FB64FF61264D0100002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C726567756C61726D617463682E6373002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C7374725F73756D2E6373002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C69735F726567756C61726D617463682E6373002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C73756D5F756E696F6E5F73756D2E637300070000000E00000001000000E126000000000000B3000000090000000A00000005000000010100000A000000000000000400000011000000060000006D00000008000000220000000700000000000000726F6A656374315C53716C53657276657250726F6A656374315C5354525F53554D2E637300443A5C70726F6A656374735C53716C53657276657250726F6A656374315C1C00000058000000BD010000380000005304000000000000580200000401000058000000580000005800000058000000E4050000FC050000380400004C0300002C00000094020000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF280000000900000025000000060000002200000023000000240000000C0000000D0000001300000007000000080000000E000000100000001400000015000000160000001700000018000000190000001A0000001B0000001C0000001D0000001E000000200000001F00000021000000110000006A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C69735F726567756C61726D617463682E6373002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C73756D5F756E696F6E5F73756D2E637300070000000E00000001000000E126000000000000B3000000090000000A00000005000000010100000A000000000000000400000011000000060000006D000000080000002200000007000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000026000000BFFD5F510A000000A7568C7938BA12408B5091FB64FF61264D0100002F4C696E6B496E666F002F6E616D6573002F7372632F686561646572626C6F636B002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C726567756C61726D617463682E6373002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C7374725F73756D2E6373002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C69735F726567756C61726D617463682E6373002F7372632F66696C65732F643A5C70726F6A656374735C73716C73657276657270726F6A656374315C73716C73657276657270726F6A656374315C73756D5F756E696F6E5F73756D2E637300070000000E00000001000000E126000000000000B3000000090000000A00000005000000010100000A000000000000000400000011000000060000006D00000008000000220000000700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001B00000058000000BD01000038000000530400000000000058020000040100005800000058000000580000005800000028060000B0060000380400004C0300002C00000094020000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF280000000900000027000000060000002400000025000000260000000C0000000D0000001200000004000000050000000B0000000F0000001400000015000000160000001700000018000000190000001A0000001B0000001C0000001D0000001E0000001F00000020000000220000002100000023000000110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 AS N'bin\Debug\SqlServerProject1.pdb';
18 
19 
20 GO
21 CREATE AGGREGATE [dbo].[STR_SUM](@Value NVARCHAR (4000))
22     RETURNS NVARCHAR (4000)
23     EXTERNAL NAME [SqlServerProject1].[STR_SUM];
24 
25 
26 GO
27 CREATE AGGREGATE [dbo].[STR_UNION_SUM](@Value NVARCHAR (4000))
28     RETURNS NVARCHAR (4000)
29     EXTERNAL NAME [SqlServerProject1].[STR_UNION_SUM];
30 
31 GO
32 CREATE FUNCTION [dbo].[IS_REGULARMATCH]
33 (@str_Source NVARCHAR (4000), @str_Regex NVARCHAR (4000))
34 RETURNS BIT
35 AS
36  EXTERNAL NAME [SqlServerProject1].[UserDefinedFunctions].[IS_REGULARMATCH]
37 
38 GO
39 CREATE FUNCTION [dbo].[REGULARMATCH]
40 (@str_Source NVARCHAR (4000), @str_Regular NVARCHAR (4000))
41 RETURNS NVARCHAR (4000)
42 AS
43  EXTERNAL NAME [SqlServerProject1].[UserDefinedFunctions].[REGULARMATCH]

posted on 2013-05-03 19:02 代岳强阅读(1029) 评论(0) 编辑收藏举报