對于您的結果: EXEC @Result = sp_OAMethod @Obj, 'close';--, NULL, 'GET', @URL, falseSELECT d.value('(./LAST_UPDATE)[1]', 'DATETIME') AS LAST_UPDATE, c.value('(./NAME)[1]', 'NVARCHAR(64)') AS NAME, c.value('(./UNIT)[1]', 'SMALLINT') AS UNIT, c.value('(./CURRENCYCODE )[1]', 'NVARCHAR(64)') AS CURRENCYCODE, c.value('(./RATE)[1]', 'DECIMAL(38,2)') AS RATEFROM #xml x CROSS APPLY x.yourXML.nodes('/CURRENCIES/CURRENCY') y(c) CROSS APPLY x.yourXML.nodes('/CURRENCIES') z(d); 不要忘記關閉OA對象。并最終禁用使用它的可能性: EXEC sp_configure 'Ole Automation Procedures', 0;RECONFIGURE; 當然,我更喜歡這個帶有表變量的版本: DECLARE @vxml TABLE (an_xml XM