_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › SQLServerHTTPCall蠍
|
|
[edit]
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
鏤
|
れ蟆 襷 蟆 朱 襦 蠍一 襷讌. |