Contents

1 覦覯1: sp_OA伎蟲 襦 伎蠍
2 覦覯2: CLR 伎蠍


1 覦覯1: sp_OA伎蟲 襦 伎蠍 #

蟲蠍 蟆覃 襷 .
覘.. 蠏碁.
/*
exec sp_configure 'show advanced options', 1;  
go  
reconfigure;  
go
exec sp_configure 'Ole Automation Procedures', 1;  
go  
reconfigure;  
go 
*/


declare
    @obj int
,   @response nvarchar(4000)

exec sp_OACreate 'MSXML2.XMLHTTP', @obj out;
exec sp_OAMethod @obj, 'open', NULL, 'get',
                 'https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USD%22%2C%22KRW%22)&diagnostics=true&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys',
                 'false'
exec sp_OAMethod @obj, 'send'
exec sp_OAMethod @obj, 'responseText', @response output

select @response

exec sp_OADestroy @obj

2 覦覯2: CLR 伎蠍 #