_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › SQLServerHTTPCall蠍

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 伎蠍 #

蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

譴 企 蟆曙一朱 語 蟒 殊 . (覯る)