_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
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
鏤
|
豺覓牛 一旧朱 覲碁 襦 螳螻 矩. れ旧 螳 伎螻 れ旧 覿′覃伎 襯 蠍磯る 覓企ゴ牛 一旧 螻 矩. 旧 螳企 殊朱 讌蠏語 豈覃伎 リ鍵襦 譯朱 覦蠍磯ゼ 蠍磯るΥ 蠍磯ゼ 覦.蠏碁Μ 襷 襷 (讌) |