DataBaser.Net: CURL InSQL Server UsingCLR

1 다른거
2 함수1
3 함수2 --> 에이.. 한글이 깨진다.

rest api call
web service call

sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

ALTER DATABASE myDatabase SET TRUSTWORTHY ON;

[edit]

1 다른거 #

/****** Object:  SqlAssembly [ClrHttpRequest]    Script Date: 2024-08-23 오전 9:10:46 ******/
CREATE ASSEMBLY [ClrHttpRequest]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300E18B475F0000000000000000E00022200B0130000026000000060000000000007E45000000200000006000000000001000200000000200000400000000000000060000000000000000A0000000020000DC4500000300608500001000001000000000100000100000000000001000000000000000000000002C4500004F00000000600000FC03000000000000000000000000000000000000008000000C000000F44300001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E7465787400000084250000002000000026000000020000000000000000000000000000200000602E72737263000000FC030000006000000004000000280000000000000000000000000000400000402E72656C6F6300000C0000000080000000020000002C0000000000000000000000000000400000420000000000000000000000000000000060450000000000004800000002000500442B00003018000009000000000000000000000000000000744300008000000000000000000000000000000000000000000000000000000000000000000000001B300800090A000001000011000F00281000000A130411042C0C7201000070281100000A10000F04281200000A130511052C0C2030750000281300000A10040F05281400000A130611062C0816281500000A10050F06281400000A130711072C0816281500000A10060F00281600000A6F1700000A7201000070281800000A2C1A0F02281000000A2D110F02281600000A281900000A16FE012B0116130811082C3200030F01281600000A1F3F6F1A00000A16300772090000702B05720D000070281100000A04281B00000A281B00000A10010020000C0000281C00000A000F01281600000A281D00000A74150000010A160B160C0F03281000000A2D110F03281600000A281900000A16FE012B0116130911093950040000000F03281600000A281E00000A130A00110A6F1F00000A6F2000000A130B3811040000110B6F2100000A130C00110C7211000070282200000A6F2300000A6F2400000A130D110C6F2500000A130E110D6F1700000A131211121311111128030000061313111320FA67BE92357D111320E9179E20352D11132058D565023B500100002B001113208915C00E3B6E0100002B00111320E9179E203BC6000000387E03000011132019C0262A351F1113204E5CE2253B9E0100002B0011132019C0262A3BB40000003856030000111320B2E121653B3D0100002B00111320FA67BE923B8701000038370300001113204669E5B9352D1113207D28CF9C3B910000002B001113200C056CB13B330100002B001113204669E5B93B0F01000038010300001113205A1ACBC9351F11132099F407C03B870000002B001113205A1ACBC93B3F01000038D9020000111320757E29EB2E552B001113202F3EF0ED3B8900000038BD0200001111721B000070281800000A3A2301000038A702000011117229000070281800000A3A1B01000038910200001111723F000070281800000A3A13010000387B0200001111725D000070281800000A3A12010000386502000011117277000070281800000A3A0C010000384F02000011117281000070281800000A3A0901000038390200001111728F000070281800000A3A01010000382302000011117299000070281800000A3AF9000000380D020000111172BD000070281800000A3AF600000038F7010000111172C9000070281800000A3A2B01000038E1010000111172D9000070281800000A3A2301000038CB010000111172FD000070281800000A3A1B01000038B501000011117213010070281800000A3A13010000389F01000011117253010070281800000A3A2B010000388901000006110E6F2600000A00388D01000006110E6F2700000A00387F01000006110E282800000A6F2900000A00170B386A01000006110E6F2A00000A00170C385A01000006110E282B00000A6F2C00000A00384701000006110E6F2D00000A00383901000006110E6F2E00000A00382B01000006110E282B00000A6F2F00000A003818010000110E178D2800000125161F2D9D6F3000000A130F110F8E6918FE04131411142C0C007297010070733100000A7A06110F169A283200000A110F179A283200000A6F3300000A0038CD00000006110E6F3400000A0038BF00000006110E6F3500000A0038B100000006110E6F3600000A0038A3000000066F3700000A72F90100707215020070283800000A110E6F3900000A283A00000A283B00000A6F3C00000A002B75110E178D2800000125161F3A9D6F3000000A131011108E6918FE04131511152C0C007223020070733100000A7A06110E178D2800000125161F3A9D6F3000000A169A110E178D2800000125161F3A9D6F3000000A179A733D00000A6F3E00000A002B12066F3700000A110D110E6F3C00000A002B0000110B6F3F00000A3AE3FBFFFFDE0D110B2C08110B6F4000000A00DC00060F00281000000A2D0E0F00281600000A6F1700000A2B0572010000706F4100000A00060F04281200000A2D090F04284200000A2B0520307500006F4300000A000F05281400000A2D090F05284400000A2B0116131611162C0A0006196F4500000A00000F00281600000A6F1700000A7201000070284600000A2C1A0F02281000000A2D110F02281600000A281900000A16FE012B0116131711172C6D00283800000A0F02281600000A6F3900000A13180716FE01131911192C0E000611188E696A6F2900000A00000816FE01131A111A2C0E000672060300706F2A00000A0000066F4700000A131B00111B11181611188E696F4800000A0000DE0D111B2C08111B6F4000000A00DC00066F4900000A7419000001131C00724A030070282200000A734A00000A131D111C6F4B00000A131E161320389700000000725A030070282200000A734A00000A132100111E11206F4C00000A13221613232B28112211239A13240011217268030070282200000A1124734D00000A6F4E00000A0000112317581323112311228E6932D0111D7274030070282200000A188D0E00000125167211000070282200000A111E11206F4F00000A734D00000AA225171121A2735000000A6F4E00000A00001120175813201120111E6F5100000AFE04132511253A55FFFFFF7E5200000A131F111C6F5300000A1326000E06285400000A132711272C3800735500000A132800112611286F5600000A0011286F5700000A13291129283A00000A131F00DE0D11282C0811286F4000000A00DC002B25001126735800000A132A00112A6F5900000A131F00DE0D112A2C08112A6F4000000A00DC0000DE0D11262C0811266F4000000A00DC7282030070282200000A1F138D0E00000125167294030070282200000A111C6F5A00000A734D00000AA2251772AE030070282200000A111C6F5B00000A734D00000AA2251872CE030070282200000A111C6F5C00000A8C26000001734D00000AA2251972EA030070282200000A111C6F5D00000A734D00000AA2251A7202040070282200000A111C6F5E00000A6F5F00000A8C2A000001734D00000AA2251B721C040070282200000A111C6F4B00000A6F5100000A8C2A000001734D00000AA2251C111DA2251D7236040070282200000A111C6F6000000A8C37000001734D00000AA2251E724E040070282200000A111C6F6100000A8C37000001734D00000AA2251F09727E040070282200000A111C6F6200000A8C27000001734D00000AA2251F0A7298040070282200000A111C6F6300000A734D00000AA2251F0B72A6040070282200000A111C6F6400000A734D00000AA2251F0C72C6040070282200000A111C6F6500000A734D00000AA2251F0D72DE040070282200000A111C6F6600000A734D00000AA2251F0E72EC040070282200000A111C6F6700000A8C3A000001734D00000AA2251F0F7202050070282200000A111C6F6700000A8C2A000001734D00000AA2251F10721C050070282200000A111C6F6800000A734D00000AA2251F117240050070282200000A111C6F6900000A8C37000001734D00000AA2251F127260050070282200000A111F734D00000AA2735000000A0D00DE0D111C2C08111C6F4000000A00DC096F6A00000A736B00000A132B2B00112B2A00000041940000020000002B010000240400004F0500000D00000000000000020000004606000013000000590600000D00000000000000020000006807000020000000880700000D0000000000000002000000A20700000D000000AF0700000D0000000000000002000000520700006E000000C00700000D00000000000000020000007406000076030000EA0900000D000000000000002202286C00000A002A000000133002002E00000002000011022C2920C59D1C810A160B2B1402076F6D00000A066120930100015A0A0717580B07026F6E00000A2F022BE1062A000042534A4201000100000000000C00000076342E302E33303331390000000005006C000000C0050000237E00002C060000EC08000023537472696E677300000000180F00006C0500002355530084140000100000002347554944000000941400009C03000023426C6F620000000000000002000001471502080900000000FA013300160000010000003C0000000300000003000000080000006E00000012000000020000000200000001000000050000000000910401000000000006003503C3060600B403C306060081029B060F00F4060000060095024B05060018034B050600E4024B0506009B034B05060055034B05060080034B050600AC024B050600C7024B0506005F02E3060600DB070A050A00030355060A00BA040F070A006E0355060A0024040F070A001D000F070A0011050F070E005B08ED0712002908DE0506000F0093000600030574000E00F901ED070E008205ED070600FD04740006000A06740006004402C306060027040A050E002206ED070E00AB01ED070E005F08ED0712003606DE0506000100930012009C01DE0512003902DE0506003D000A050600A2010A050600EE050A050600B1050A05060020000A0506000C04B008060053080A050E006E05DF000E007F04ED070E003707ED0706007B065407060090010A050E00AE06ED070E00FD01ED070E00E001DF000600170674000E005D05ED07060014050A05060028050A050E007B040A050E006201ED0712007101DE0516000006AF04000000004C00000000000100010001001000670700003900010001000001000055000000390001000300502000000000960079086B020100FC2A000000008618950606000800082B0000000093002E047E020800000001001E0100000200D60400000300AE0700000400A607000005009F0800000600B90700000700260000000100D207090095060100110095060600190095060A00290095061000310095061000390095061000410095061000490095061000510095061000590095061000610095061000690095061000790095060600890095060600E900950606009100A4045B00910009085F009900A4045B00990009086500A100A4045B00A10009086B009100D2037100F10041067100F100CB087500F1002C017B00F100E40380009100A5058500F900C1048E0009012C029500B1001D029C001101C807A2000C008706B40014003208C40021010908C900B100C803D0002901D2037100B100D2037100A90048081000A9009605100031011D02D90009015D04DE000901D001100039011D02E300A9002302EA00A900E2071000A9008A081000A9003F01EA00F1001508F10049019506100051011D02F800A9007701FD00A90049061000A900EC031000A9001B081000090186070301590143000801590124070E01610115041401F100D4071A016901AE0020017101950620010901440726018101A7085B008901150206000901130110009900D2032D01090193080100A100D2035B00A90030053101F100D70875000901EC043801C10033023D01090109024501B10095064B0199018607030169012D075201B100950658011101AE0060016901C4086501B10095066A01A1013E082D01F100E50873019901DA043801A100DC037601D90095060600C100D7057C01D900BC088201E10095067C01A901FE007100C900F8077100C9000104710099014B0487019901C0017100C90003078B01B1013E082D01990180015B009901C3005B00C900B2009101C90008017100C9001C05970199016F049D01C90070067100C9005301A301C900C1057100990192075B00D901F305A90181009506AF01710095060600F1007C07BB01F10040042D0120006B003F032400730044032E000B0083022E0013008C022E001B00AB022E002300B4022E002B00C8022E003300FD022E003B00FD022E004300B4022E004B0003032E005300FD022E005B0015032E006300220344007300570363007B003F036400730078038400730078031500B601AC00BD0004800000030000000000000001000000C9016A080000040000000000000000000000C0018A0000000000040000000000000000000000C0017E0000000000040000000000000000000000C0010A0500000000040000000000000000000000C001DE0500000000040000000000000000000000C001AF0400000000000000000049456E756D657261626C6560310049456E756D657261746F7260310053716C496E74333200636F6E76657274526573706F6E7365546F426173363400496E743634006765745F55544638003C4D6F64756C653E003C50726976617465496D706C656D656E746174696F6E44657461696C733E0053797374656D2E494F0053797374656D2E44617461006D73636F726C69620053797374656D2E436F6C6C656374696F6E732E47656E6572696300416464006765745F4C6173744D6F646966696564006765745F49734D757475616C6C7941757468656E746963617465640053797374656D2E436F6C6C656374696F6E732E5370656369616C697A65640052656164546F456E64006765745F4D6574686F64007365745F4D6574686F6400726571756573744D6574686F640049734E756C6C4F7257686974655370616365007365745F49664D6F64696669656453696E6365006765745F537461747573436F64650048747470537461747573436F646500584E6F64650041646452616E6765006765745F497346726F6D43616368650049446973706F7361626C6500584E616D65004461746554696D6500536563757269747950726F746F636F6C54797065006765745F436F6E74656E7454797065007365745F436F6E74656E7454797065004E616D654F626A656374436F6C6C656374696F6E426173650048747470576562526573706F6E736500476574526573706F6E736500446973706F7365005061727365007365745F4461746500437265617465005772697465005841747472696275746500436F6D70696C657247656E657261746564417474726962757465004E65757472616C5265736F75726365734C616E67756167654174747269627574650044656275676761626C6541747472696275746500417373656D626C795469746C6541747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7946696C6556657273696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E4174747269627574650053716C46756E6374696F6E41747472696275746500417373656D626C794465736372697074696F6E41747472696275746500436F6D70696C6174696F6E52656C61786174696F6E7341747472696275746500417373656D626C7950726F647563744174747269627574650053716C466163657441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C79436F6D70616E794174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465006765745F56616C7565006F705F5472756500496E6465784F66007365745F5472616E73666572456E636F64696E67006765745F436F6E74656E74456E636F64696E6700546F426173653634537472696E670053716C537472696E6700436F6D70757465537472696E6748617368006765745F4C656E677468006765745F436F6E74656E744C656E677468007365745F436F6E74656E744C656E677468006765745F526573706F6E7365557269004E6574776F726B43726564656E7469616C00436C7248747470526571756573742E646C6C006765745F49734E756C6C0053797374656D2E586D6C0053716C586D6C007365745F536563757269747950726F746F636F6C0075726C00476574526573706F6E736553747265616D004765745265717565737453747265616D004D656D6F727953747265616D0053797374656D0053716C426F6F6C65616E006765745F50726F746F636F6C56657273696F6E007365745F4175746F6D617469634465636F6D7072657373696F6E0053797374656D2E5265666C656374696F6E00436F6F6B6965436F6C6C656374696F6E004E616D6556616C7565436F6C6C656374696F6E00576562486561646572436F6C6C656374696F6E007365745F436F6E6E656374696F6E006F705F4164646974696F6E00466F726D6174457863657074696F6E006765745F5374617475734465736372697074696F6E00436F7079546F0053797374656D2E586D6C2E4C696E7100436861720043726561746552656164657200586D6C5265616465720053747265616D52656164657200546578745265616465720053657276696365506F696E744D616E616765720058436F6E7461696E657200546F5570706572007365745F52656665726572004D6963726F736F66742E53716C5365727665722E536572766572006765745F5365727665720049456E756D657261746F7200476574456E756D657261746F72002E63746F720053797374656D2E446961676E6F7374696373004465636F6D7072657373696F6E4D6574686F64730053797374656D2E52756E74696D652E436F6D70696C657253657276696365730053797374656D2E5265736F757263657300446562756767696E674D6F646573006765745F436F6F6B6965730053797374656D2E446174612E53716C54797065730047657442797465730047657456616C756573004943726564656E7469616C73007365745F43726564656E7469616C730053797374656D2E436F6C6C656374696F6E730055736572446566696E656446756E6374696F6E73006765745F4368617273006765745F48656164657273006765745F537570706F72747348656164657273006865616465727300706172616D6574657273006175746F4465636F6D70726573730044657363656E64616E747300436F6E636174004F626A656374007365745F4578706563740053797374656D2E4E6574006765745F436861726163746572536574006F705F496D706C696369740053706C6974007365745F557365724167656E740058456C656D656E74006765745F43757272656E74006765745F436F756E74007365745F41636365707400436F6E7665727400487474705765625265717565737400436C72487474705265717565737400636C725F687474705F72657175657374007365745F486F7374007365745F54696D656F75740074696D656F7574004D6F76654E6578740053797374656D2E5465787400546F4172726179004765744B6579006F705F457175616C697479006F705F496E657175616C69747900456D7074790000000747004500540000033F000003260000094E0061006D006500000D410043004300450050005400001543004F004E004E0045004300540049004F004E00001D43004F004E00540045004E0054002D004C0045004E00470054004800011943004F004E00540045004E0054002D00540059005000450001094400410054004500000D450058005000450043005400000948004F00530054000023490046002D004D004F004400490046004900450044002D00530049004E0043004500010B520041004E0047004500000F520045004600450052004500520000235400520041004E0053004600450052002D0045004E0043004F00440049004E004700011555005300450052002D004100470045004E005400013F41005500540048004F00520049005A004100540049004F004E002D00420041005300490043002D00430052004500440045004E005400490041004C005300014341005500540048004F00520049005A004100540049004F004E002D004E004500540057004F0052004B002D00430052004500440045004E005400490041004C0053000161520061006E006700650020006D007500730074002000620065002000730070006500630069006600690065006400200069006E0020006100200066006F0072006D006100740020006F0066002000730074006100720074002D0065006E006400011B41007500740068006F00720069007A006100740069006F006E00000D4200610073006900630020000080E15700680065006E002000730070006500630069006600790069006E006700200041007500740068006F00720069007A006100740069006F006E002D004E006500740077006F0072006B002D00430072006500640065006E007400690061006C007300200068006500610064006500720073002C00200070006C006500610073006500200073006500740020007400680065002000760061006C0075006500200069006E0020006100200066006F0072006D006100740020006F006600200075007300650072006E0061006D0065003A00700061007300730077006F007200640001436100700070006C00690063006100740069006F006E002F0078002D007700770077002D0066006F0072006D002D00750072006C0065006E0063006F00640065006400010F4800650061006400650072007300000D560061006C00750065007300000B560061006C0075006500000D480065006100640065007200001152006500730070006F006E00730065000019430068006100720061006300740065007200530065007400001F43006F006E00740065006E00740045006E0063006F00640069006E006700001B43006F006E00740065006E0074004C0065006E00670074006800001743006F006E00740065006E0074005400790070006500001943006F006F006B0069006500730043006F0075006E0074000019480065006100640065007200730043006F0075006E007400001749007300460072006F006D0043006100630068006500002F490073004D0075007400750061006C006C007900410075007400680065006E00740069006300610074006500640000194C006100730074004D006F00640069006600690065006400000D4D006500740068006F006400001F500072006F0074006F0063006F006C00560065007200730069006F006E00001752006500730070006F006E0073006500550072006900000D530065007200760065007200001553007400610074007500730043006F006400650000195300740061007400750073004E0075006D0062006500720000235300740061007400750073004400650073006300720069007000740069006F006E00001F53007500700070006F007200740073004800650061006400650072007300000942006F006400790000000089D2FBDC924E4D458CFF6FC3CFC46A7B00042001010803200001052001011111042001010E45072C125502021259020202020202125915125D01125912590E0E1D0E1D0E0E0E09020202021D05020212611265125912690E0812591D0E080E02126102126D1D05127112410320000205000111490E050001114D080500011151020320000E050002020E0E040001020E0420010803080002114911491149060001011180810600011280850E05000112590E0920001512808D011259071512808D01125908200015125D0113000615125D01125904200013000600011280910E0820011280951280910400010A0E042001010A06000111809D0E0620010111809D0620011D0E1D03040001080E05200201080804200012690500001280AD0520011D050E0500010E1D050500020E0E0E052002010E0E062001011280BD03200008062001011180C90420001261072003011D0508080520001280CD062001011280910520011D0E08072002011280911C042001011C0420010E08082002011280911D1C02060E0500010211510520010112610420001D050320000A0520001280D905200011809D0520001280E10520001280E50520001180E90520001280F1062001011280F10407020908042001030808B77A5C561934E08980A000240000048000009400000006020000002400005253413100040000010001003D8E79BAE28F492EE9B3A5997E7ED6336551C0F78360D7D8B1EED2082F0DDEDB343410B470CFD74E7A22880DDE5DDF63E22F26B37E1CD10051FE2A8F6885DAB5341D5677C59ADA7D2EF303A9429F7D275A015BB9DF1D3DEE0009E595DD31A9AAA08967A14C6B4E4CEA1240111F4FD44FC24D3FADB36B320B44AFF163B289C5BB12000712411149114911491149114D11511151040001090E0801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010801000701000000001301000E436C72487474705265717565737400003401002F434C522066756E6374696F6E20666F722072756E6E696E672052455354206D6574686F6473206F766572204854545000000501000000001101000C456974616E20426C756D696E00000C010007332E302E302E3000001C010017456E676C6973682028556E6974656420537461746573290000040100000012010001005408074D617853697A650A00000020010002005408074D617853697A65FFFFFFFF54020A49734E756C6C61626C650020010002005408074D617853697A65FFFFFFFF54020A49734E756C6C61626C650100000024BBA9050B70E9BE11829720EDE8EA8A6BF750E349027B88983B0A2E338F860B865A149B2C20CF2473A9C099A12C4DFC940847217F3819E7D3DEB3BB5B39724CD630CB3446F8BA34A13CE477AF7AF741258FE13CFF4AB1F8D063FBF0502EB2019B541BF350DC62EA68FA5EF7B0EE9B7088CBC1118E02C6ABD232C00442869BBB00000000E18B475F00000000020000001C010000104400001026000052534453229CBBD454BA0344AF6CA6223AEE04A501000000433A5C55736572735C456974616E426C756D696E5C536F757263655C5265706F735C436C7248747470526571756573745C436C7248747470526571756573745C6F626A5C44656275675C436C7248747470526571756573742E7064620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000005445000000000000000000006E45000000200000000000000000000000000000000000000000000060450000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058600000A00300000000000000000000A00334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000003000000000000000300000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00400030000010053007400720069006E006700460069006C00650049006E0066006F000000DC020000010030003000300030003000340062003000000078003000010043006F006D006D0065006E0074007300000043004C0052002000660075006E006300740069006F006E00200066006F0072002000720075006E006E0069006E0067002000520045005300540020006D006500740068006F006400730020006F0076006500720020004800540054005000000022000100010043006F006D00700061006E0079004E0061006D006500000000000000000046000F000100460069006C0065004400650073006300720069007000740069006F006E000000000043006C0072004800740074007000520065007100750065007300740000000000300008000100460069006C006500560065007200730069006F006E000000000033002E0030002E0030002E003000000046001300010049006E007400650072006E0061006C004E0061006D006500000043006C007200480074007400700052006500710075006500730074002E0064006C006C00000000003E000D0001004C006500670061006C0043006F007000790072006900670068007400000045006900740061006E00200042006C0075006D0069006E00000000002A00010001004C006500670061006C00540072006100640065006D00610072006B00730000000000000000004E00130001004F0072006900670069006E0061006C00460069006C0065006E0061006D006500000043006C007200480074007400700052006500710075006500730074002E0064006C006C00000000003E000F000100500072006F0064007500630074004E0061006D0065000000000043006C0072004800740074007000520065007100750065007300740000000000340008000100500072006F006400750063007400560065007200730069006F006E00000033002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000033002E0030002E0030002E00300000000000000000000000004000000C000000803500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = EXTERNAL_ACCESS
GO


ALTER FUNCTION [dbo].[clr_http_request](@requestMethod [nvarchar](10), @url [nvarchar](max), @parameters [nvarchar](max), @headers [nvarchar](max), @timeout [int], @autoDecompress [bit], @convertResponseToBas64 [bit])
RETURNS [xml] WITH EXECUTE AS CALLER
AS 
EXTERNAL NAME [ClrHttpRequest].[UserDefinedFunctions].[clr_http_request]
go

declare @result nvarchar(max)
select @result = dbo.clr_http_request('GET', @uri, NULL, NULL, 1800000, 0, 0).value('Response[1]/Body[1]', 'NVARCHAR(MAX)')
select @result

[edit]

2 함수1 #

https://sqlsunday.com/2013/03/03/web-requests-using-clr-proc/

SqlWebRequest.cs

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Collections;
using System.Globalization;

// For the SQL Server integration
using Microsoft.SqlServer.Server;

// Other things we need for WebRequest
using System.Net;
using System.Text;
using System.IO;

public partial class Functions
{
   // Function to return a web URL as a string value.
    [Microsoft.SqlServer.Server.SqlFunction(DataAccess=DataAccessKind.Read)]
    public static SqlString GET(SqlString uri, SqlString username, SqlString passwd)
    {
        // The SqlPipe is how we send data back to the caller
        SqlPipe pipe = SqlContext.Pipe;
        SqlString document;

        // Set up the request, including authentication
        WebRequest req = WebRequest.Create(Convert.ToString(uri));
        if (Convert.ToString(username) != null & Convert.ToString(username) != "")
        {
            req.Credentials = new NetworkCredential(
                Convert.ToString(username),
                Convert.ToString(passwd));
        }
        ((HttpWebRequest)req).UserAgent = "CLR web client on SQL Server";

        // Fire off the request and retrieve the response.
        // We'll put the response in the string variable "document".
        WebResponse resp = req.GetResponse();
        Stream dataStream = resp.GetResponseStream();
        StreamReader rdr = new StreamReader(dataStream);
        document = (SqlString)rdr.ReadToEnd();

        // Close up everything...
        rdr.Close();
        dataStream.Close();
        resp.Close();

        // .. and return the output to the caller.
        return (document);
    }

    // Function to submit a HTTP POST and return the resulting output.
    [Microsoft.SqlServer.Server.SqlFunction(DataAccess = DataAccessKind.Read)]
    public static SqlString POST(SqlString uri, SqlString postData, SqlString username, SqlString passwd)
    {
        SqlPipe pipe = SqlContext.Pipe;
        SqlString document;
        byte[] postByteArray = Encoding.UTF8.GetBytes(Convert.ToString(postData));

        // Set up the request, including authentication, 
        // method=POST and encoding:
        WebRequest req = WebRequest.Create(Convert.ToString(uri));
        ((HttpWebRequest)req).UserAgent = "CLR web client on SQL Server";
        if (Convert.ToString(username) != null & Convert.ToString(username) != "")
        {
            req.Credentials = new NetworkCredential(
                Convert.ToString(username),
                Convert.ToString(passwd));
        }
        req.Method = "POST";
        req.ContentType = "application/x-www-form-urlencoded";

        // Submit the POST data
        Stream dataStream = req.GetRequestStream();
        dataStream.Write(postByteArray, 0, postByteArray.Length);
        dataStream.Close();

        // Collect the response, put it in the string variable "document"
        WebResponse resp = req.GetResponse();
        dataStream = resp.GetResponseStream();
        StreamReader rdr = new StreamReader(dataStream);
        document = (SqlString)rdr.ReadToEnd();

        // Close up and return
        rdr.Close();
        dataStream.Close();
        resp.Close();

        return (document);
    }
}

CREATE ASSEMBLY [SqlWebRequest]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103009DA5E35C0000000000000000E00002210B010800000C00000006000000000000FE290000002000000040000000004000002000000002000004000000000000000400000000000000008000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000A82900005300000000400000B802000000000000000000000000000000000000006000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000040A000000200000000C000000020000000000000000000000000000200000602E72737263000000B80200000040000000040000000E0000000000000000000000000000400000402E72656C6F6300000C0000000060000000020000001200000000000000000000000000004000004200000000000000000000000000000000E02900000000000048000000020005005C2200004C070000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000013300400CD0000000100001100280400000A0A028C02000001280500000A280600000A0C082080EE36006F0700000A00038C02000001280500000A14FE0116FE01038C02000001280500000A7201000070280800000A5F16FE01130711072D240008038C02000001280500000A048C02000001280500000A730900000A6F0A00000A000008740D00000172030000706F0B00000A00086F0C00000A0D096F0D00000A13041104730E00000A130511056F0F00000A281000000A0B11056F1100000A0011046F1200000A00096F1300000A000713062B0011062A000000133004001B0100000200001100280400000A0A281400000A038C02000001280500000A6F1500000A0C028C02000001280500000A280600000A0D092080EE36006F0700000A0009740D00000172030000706F0B00000A00048C02000001280500000A14FE0116FE01048C02000001280500000A7201000070280800000A5F16FE01130811082D240009048C02000001280500000A058C02000001280500000A730900000A6F0A00000A000009723D0000706F1600000A000972470000706F1700000A00096F1800000A130411040816088E696F1900000A0011046F1200000A00096F0C00000A130511056F0D00000A13041104730E00000A130611066F0F00000A281000000A0B11066F1100000A0011046F1200000A0011056F1300000A000713072B0011072A1E02281A00000A2A0042534A4201000100000000000C00000076322E302E35303732370000000005006C00000034020000237E0000A0020000B002000023537472696E677300000000500500008C00000023555300DC050000100000002347554944000000EC0500006001000023426C6F620000000000000002000001471502000900000000FA01330016000001000000120000000200000003000000070000001A0000000400000002000000010000000300000000000A00010000000000060036002F000A005E0049000600B40094000600D40094000A001B0100010A00300100010A003B01000106004C012F000E0068015D01060086012F000E009B015D010E00AD015D010E00CA015D010E00E7015D0106000902FF0106002202FF0106002F02FF010600620256020000000001000000000001000100010010001C000000050001000100502000000000960068000A0001002C210000000096006C00150004005322000000008618710022000800000001007700000002007B00000003008400000001007700000002008B00000003007B0000000400840019007100260021007100220029007100220031004301BC0041005401C10049007301C60049007A01260051008D01CC0059007100D2004900BA01D8006900D901DE004900F301E30071001002E80081007100ED0089003A02F30011004402F70089005002220079005002220071005002220091006B020F0191007402140149007D02DE0049008802DE0049009802E8007900A9021A0109007100220020001B002B002E0013003F012E000B00360140001B002B00FD002201048000000000000000000000000000000000F2000000020000000000000000000000010026000000000002000000000000000000000001003D000000000002000000000000000000000001002F000000000000000000003C4D6F64756C653E0053716C576562526571756573742E646C6C0046756E6374696F6E73006D73636F726C69620053797374656D004F626A6563740053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E670047455400504F5354002E63746F720075726900757365726E616D650070617373776400706F7374446174610053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053716C57656252657175657374004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E4174747269627574650053716C436F6E746578740053716C50697065006765745F5069706500436F6E7665727400546F537472696E670053797374656D2E4E6574005765625265717565737400437265617465007365745F54696D656F757400537472696E67006F705F496E657175616C697479004E6574776F726B43726564656E7469616C004943726564656E7469616C73007365745F43726564656E7469616C73004874747057656252657175657374007365745F557365724167656E7400576562526573706F6E736500476574526573706F6E73650053797374656D2E494F0053747265616D00476574526573706F6E736553747265616D0053747265616D52656164657200546578745265616465720052656164546F456E64006F705F496D706C6963697400436C6F73650053797374656D2E5465787400456E636F64696E67006765745F55544638004765744279746573007365745F4D6574686F64007365745F436F6E74656E7454797065004765745265717565737453747265616D00577269746500000001003943004C0052002000770065006200200063006C00690065006E00740020006F006E002000530051004C002000530065007200760065007200000950004F005300540000436100700070006C00690063006100740069006F006E002F0078002D007700770077002D0066006F0072006D002D00750072006C0065006E0063006F00640065006400010075FA4C96B7C1744AA5FEC13BB807A99C0008B77A5C561934E0890A000311091109110911090C000411091109110911091109032000010420010108808F010001005455794D6963726F736F66742E53716C5365727665722E5365727665722E446174614163636573734B696E642C2053797374656D2E446174612C2056657273696F6E3D322E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038390A4461746141636365737301000000040000121D0400010E1C05000112250E050002020E0E052002010E0E052001011231042001010E0420001239042000123D05200101123D0320000E05000111090E110708121D110912251239123D124111090204000012490520011D050E072003011D050808130709121D11091D051225123D123912411109020801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010000D02900000000000000000000EE290000002000000000000000000000000000000000000000000000E029000000000000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001001000000018000080000000000000000000000000000001000100000030000080000000000000000000000000000001000000000048000000584000005C02000000000000000000005C0234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000000000000000000000000000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004BC010000010053007400720069006E006700460069006C00650049006E0066006F0000009801000001003000300030003000300034006200300000002C0002000100460069006C0065004400650073006300720069007000740069006F006E000000000020000000300008000100460069006C006500560065007200730069006F006E000000000030002E0030002E0030002E003000000044001200010049006E007400650072006E0061006C004E0061006D0065000000530071006C0057006500620052006500710075006500730074002E0064006C006C0000002800020001004C006500670061006C0043006F0070007900720069006700680074000000200000004C00120001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C0057006500620052006500710075006500730074002E0064006C006C000000340008000100500072006F006400750063007400560065007200730069006F006E00000030002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000030002E0030002E0030002E00300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000003A00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = UNSAFE
GO

컴파일(명령 프롬프트, 관리자 권한으로 실행

cd C:\Windows\Microsoft.NET\Framework64\v3.5
csc.exe /t:library  "D:\Microsoft SQL Server\clr\SqlWebRequest.cs"
copy SqlWebRequest.dll "D:\Microsoft SQL Server\clr"

create function

CREATE ASSEMBLY SqlWebRequest
FROM 'D:\Microsoft SQL Server\clr\SqlWebRequest.dll'
WITH PERMISSION_SET=UNSAFE;
GO


CREATE FUNCTION dbo.fn_get_webrequest(
     @uri        nvarchar(max),
     @user       nvarchar(255)=NULL,
     @passwd     nvarchar(255)=NULL
)
RETURNS nvarchar(max)
AS
EXTERNAL NAME SqlWebRequest.Functions.GET;
GO

CREATE FUNCTION dbo.fn_post_webrequest(
     @uri         nvarchar(max),
     @postdata    nvarchar(max),
     @user        nvarchar(255)=NULL,
     @passwd      nvarchar(255)=NULL
)
RETURNS nvarchar(max)
AS
EXTERNAL NAME SqlWebRequest.Functions.POST;
GO

[edit]

3 함수2 --> 에이.. 한글이 깨진다. #

아래꺼는 한글이 깨진다.
https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/sql-clr/Curl

sp_configure @configname=clr_enabled, @configvalue=1
GO
RECONFIGURE
GO

EXEC sp_add_trusted_assembly 0xF9251BA2BBA78E1462F07ABBF45216B6FB3C8EE702940066607C5BAE76147DBDA9A325A0989B5AA45B5BF26EFEF7A2229C8B8DB17D2518BDFC7E18EFC78806D7
GO

CREATE ASSEMBLY [SqlClrCurl]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C0103004D0BD75A0000000000000000E00022200B013000001000000008000000000000AA2E00000020000000400000000000100020000000020000040000000000000006000000000000000080000000020000719A0000030060850000100000100000000010000010000000000000100000000000000000000000582E00004F000000004000002C04000000000000000000000000000000000000006000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B00E0000002000000010000000020000000000000000000000000000200000602E727372630000002C040000004000000006000000120000000000000000000000000000400000402E72656C6F6300000C00000000600000000200000018000000000000000000000000000040000042000000000000000000000000000000008C2E000000000000480000000200050044220000940B000009000000000000000000000000000000D82D0000800000000000000000000000000000000000000000000000000000000000000000000000133002003100000001000011731200000A0A0206280400000606036F1300000A0B1201281400000A281500000A6F1600000A6F1700000A731800000A2A000000133003006300000002000011731200000A0A02062804000006036F1900000A2C1072010000707271000070731A00000A7A06046F1300000A0C1202281400000A281500000A036F1300000A0C1202281400000A6F1B00000A0B281C00000A727700007007281D00000A6F1E00000A2A001B300500D500000003000011731200000A0A02062804000006036F1900000A2C1072010000707271000070731A00000A7A7E010000040B72A10000700C0006046F1300000A0D1203281400000A281500000A036F1300000A0D1203281400000A6F1B00000A0C150BDE5D1304281C00000A1B8D10000001251672A3000070A2251711046F1F00000AA2251872B3000070A225197E020000048C1D000001A2251A72C9000070A2282000000A6F1E00000A0717590B7E02000004282100000ADE0007163D76FFFFFF07153315281C00000A727700007008281D00000A6F1E00000A2A00000001100000000032002C5E005617000001133002002C00000004000011026F1900000A2D23026F1300000A0B1201281400000A0A06282200000A2D0C036F2300000A066F2400000A2A1E02282500000A2A3A1980010000041F3280020000042A0042534A4201000100000000000C00000076342E302E33303331390000000005006C0000006C030000237E0000D80300001404000023537472696E677300000000EC070000D400000023555300C0080000100000002347554944000000D0080000C402000023426C6F620000000000000002000001571502000900000000FA013300160000010000001F0000000200000002000000060000000B0000002500000012000000040000000100000003000000000095020100000000000600870163030600060263030600900031030F00830300000600B800C10206006A01C10206003601C1020600ED01C1020600A701C1020600D201C1020600E500C1020600A400440306008200440306001901C102060000013F020600C303BA020A00550109030A00C00109030A00A70392030E00D903CE030A00870292030A00CF0009030600EF02BA020E009102BA0206008A02BA020600E702BA020A00EF0309030A007A00090306000100BA02060042002E020E00D302CE03000000000700000000000100010001001000B50200004100010001003100210033013100120033015020000000009600CA03360101009020000000009600EA033F010400002100000000960006043F010700F421000000009100FF0249010A002C22000000008618240306000C0034220000000091182A0351010C0000000000000000000100100000000200B60200000100100000000200500000000300B60200000100100000000200500000000300B60200000100100000000200E303090024030100110024030600190024030A00290024031000310024031000390024031000410024031000490024031000510024031000590024031000610024031500690024031000710024031000790024031000890024030600910024030600B10024030600A10024030600990085022100A90024022600C10075022A00A10059022F00C900FA0334009900240339009900A4024700D10024034B00A10068025100D90071005700C900BC035C00E1004D001000B90065002600C900BC036D00F100F9027300C90052007E00A100B0038300F9004900100081002403060020007B00A90224008300AE022E000B0055012E0013005E012E001B007D012E00230086012E002B0096012E003300D8012E003B00DE012E004300ED012E004B000C022E005300D8012E005B00D8012E00630024022E006B004E022E0073005B0240008B00A90260008B00A9021A003F0062007800048000000100000000000000010000009100AF020000040000000000000000000000880039000000000004000000000000000000000088002D00000000000400000000000000000000008800BA0200000000000000496E743332003C4D6F64756C653E00480044454C41595F4F4E5F4552524F520052455452595F434F554E540053797374656D2E44617461006D73636F726C696200546872656164004164640053656E640049734E756C6C4F7257686974655370616365006765745F4D657373616765006765745F506970650053716C5069706500477569644174747269627574650044656275676761626C6541747472696275746500436F6D56697369626C6541747472696275746500417373656D626C795469746C654174747269627574650053716C50726F63656475726541747472696275746500417373656D626C7954726164656D61726B417474726962757465005461726765744672616D65776F726B41747472696275746500417373656D626C7946696C6556657273696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E4174747269627574650053716C46756E6374696F6E41747472696275746500417373656D626C794465736372697074696F6E41747472696275746500436F6D70696C6174696F6E52656C61786174696F6E7341747472696275746500417373656D626C7950726F647563744174747269627574650053716C466163657441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C79436F6D70616E794174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465006765745F56616C75650053797374656D2E546872656164696E670053797374656D2E52756E74696D652E56657273696F6E696E6700446F776E6C6F6164537472696E670055706C6F6164537472696E6700457363617065557269537472696E6700546F53716C537472696E67005572690053716C436C724375726C2E646C6C006765745F49734E756C6C0053716C436C724375726C0053797374656D0053797374656D2E5265666C656374696F6E00576562486561646572436F6C6C656374696F6E00417267756D656E74457863657074696F6E00536C65657000416464486561646572004D6963726F736F66742E53716C5365727665722E536572766572002E63746F72002E6363746F720053797374656D2E446961676E6F73746963730053797374656D2E52756E74696D652E496E7465726F7053657276696365730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300446562756767696E674D6F6465730053797374656D2E446174612E53716C54797065730053716C4368617273006765745F4865616465727300436F6E636174004F626A656374004765740053797374656D2E4E657400576562436C69656E7400636C69656E7400506F73740053716C436F6E7465787400546F43686172417272617900506F737457697468526574727900006F59006F00750020006D007500730074002000730070006500630069006600790020006400610074006100200074006800610074002000770069006C006C002000620065002000730065006E007400200074006F002000740068006500200065006E00640070006F0069006E007400000540006400002952006500710075006500730074002000690073002000650078006500630075007400650064002E000001000F4500720072006F0072003A00090000152E002000570061006900740069006E006700200000076D0073002E0000000000210EB3B0DCE94F419AB644C8C813459F00042001010803200001052001011111042001010E04200101020607021251115504200011550320000E0400010E0E0420010E0E0420001D03052001011D0307070312510E115503200002052002010E0E0520020E0E0E04000012710500020E0E0E0A07051251080E1155125D0500010E1D1C04000101080507020E1155040001020E042000127D08B77A5C561934E08980A00024000004800000940000000602000000240000525341310004000001000100594568514168B07173B4258E3B5DCAC316DAE3F3C0C01DDFDBC628534C3F8D1A4F378F74CDD858CDB90804D5A862842BC650F764CBD8EC01C5C69A9EC1BFA90012AC45AC19B8198569A6E06671977DE65FC6939CFC20366252416CFFEA1DEDBB035134658E4C113C92CBA6CB1D32233F033102809E95F0D16B0C1E25E0352CB6020608080002124D124D124D09000301124D124D124D07000201124D1251030000010801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F7773010801000200000000000F01000A53716C436C724375726C00004101003C496D706C656D656E746174696F6E206F66204355524C20636F6D6D616E6420696E2053514C2053657276657220446174616261736520456E67696E6500000501000000000E0100094D6963726F736F667400001E01001953716C20536572766572204769744875622053616D706C6573000017010012436F7079726967687420C2A920203230313800002901002432363565306263332D616435662D343466332D626231372D63363166373762393834376600000C010007312E302E302E3000004D01001C2E4E45544672616D65776F726B2C56657273696F6E3D76342E362E310100540E144672616D65776F726B446973706C61794E616D65142E4E4554204672616D65776F726B20342E362E31040100000012010001005408074D617853697A65FFFFFFFF0000009B5D68E6D8B6CFDE25C606C2D49B6121BF8910B0A157824E3480F21D4099D140407F550D1F59CEB3A7F9F37EF533CD3B4AE28FF95D91461162B6B93719086F3FE7500E27DC21295E10C95B5B95A68F4EF3A9D61C05D877ACEBD3BA038CFF6A1633DB4B9D64A1ACC2BACBD480901472A5D0DA9859F8BD5E298BD8143B8A29A25F802E000000000000000000009A2E00000020000000000000000000000000000000000000000000008C2E0000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF250020001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000D00300000000000000000000D00334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00430030000010053007400720069006E006700460069006C00650049006E0066006F0000000C030000010030003000300030003000340062003000000092003D00010043006F006D006D0065006E0074007300000049006D0070006C0065006D0065006E0074006100740069006F006E0020006F00660020004300550052004C00200063006F006D006D0061006E006400200069006E002000530051004C002000530065007200760065007200200044006100740061006200610073006500200045006E00670069006E0065000000000034000A00010043006F006D00700061006E0079004E0061006D006500000000004D006900630072006F0073006F006600740000003E000B000100460069006C0065004400650073006300720069007000740069006F006E0000000000530071006C0043006C0072004300750072006C0000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E00300000003E000F00010049006E007400650072006E0061006C004E0061006D0065000000530071006C0043006C0072004300750072006C002E0064006C006C00000000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020002000320030003100380000002A00010001004C006500670061006C00540072006100640065006D00610072006B007300000000000000000046000F0001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C0043006C0072004300750072006C002E0064006C006C000000000054001A000100500072006F0064007500630074004E0061006D00650000000000530071006C00200053006500720076006500720020004700690074004800750062002000530061006D0070006C00650073000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000C000000AC3E00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = EXTERNAL_ACCESS
GO

CREATE SCHEMA CURL;
GO

--Create the function/procedure
CREATE FUNCTION CURL.XGET (@H NVARCHAR(MAX), @url NVARCHAR(4000))
RETURNS NVARCHAR(MAX)
AS EXTERNAL NAME SqlClrCurl.Curl.Get;
GO
CREATE PROCEDURE CURL.XPOST (@H NVARCHAR(MAX), @d NVARCHAR(MAX), @url NVARCHAR(4000))
AS EXTERNAL NAME SqlClrCurl.Curl.Post;
GO


select curl.xget(null, 'https://api.iextrading.com/1.0/stock/msft/earnings')

Contents

1 다른거 #

2 함수1 #

3 함수2 --> 에이.. 한글이 깨진다. #