Question

怎么获得接口数据(XML格式的)，然后导入SQL,最好有个简单的例子

从对方的程序上获取的，就是通过https接口..
例如：GET https:)order/contents?name=complete

Answer 1

/* OpenXML function */
declare @xmldoc varchar(2000); /* 这个变量的值就是你得到的xml串 */
declare @idoc int;
set @xmldoc ='
<Site URL="http://www.contoso.com/index.htm">
<Site URL="http://www.contoso.com/finance/index.htm">
<Site URL="http://www.contoso.com/finance/reports/index.htm" />
<Site URL="http://www.contoso.com/finance/main/index.htm" />
</Site>
<Site URL="http://www.contoso.com/marketing/index.htm">
<Site URL="http://www.contoso.com/marketing/reports/index.htm" />
<Site URL="http://www.contoso.com/marketing/main/index.htm" />
</Site>
<Site URL="http://www.contoso.com/sales/index.htm" />
</Site>';
exec sp_xml_preparedocument @idoc output, @xmldoc;
select ParentSiteURL, SiteURL
from openxml(@idoc,'//Site',1)
with (
ParentSiteURL nvarchar(512) '../@URL'
,SiteURL nvarchar(521) '@URL'
);