27,580
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="gbk" ?>
- <response>
<status>0</status>
<desc>success</desc>
- <content>
<field name="张三" type="string">北京市XX路XX号</field>
</content>
</response>
declare @x as xml
select @x='<?xml version="1.0" encoding="GBK"?>
<response>
<status>0</status>
<desc>success</desc>
<content>
<field name="张三" type="string">北京市XX路XX号</field>
</field>
</content>
</response>'
select CAST(@x.query('./response/content/field/text()') AS VARCHAR(8000))
不懂,帮顶,学习,蹭分.
DECLARE
@url VARCHAR(100),
@xPtr INT,
@x VARCHAR(8000),
@err INT
SET @url = 'http://58.50.25.6:99/test.xml'
EXEC @err=sp_OACreate 'Microsoft.XMLHTTP',@xPtr OUT
EXEC @err=sp_OAMethod @xPtr,'Open',NULL,'POST',@url,'False'
EXEC @err=sp_OAMethod @xPtr,'Send',NULL,NULL
EXEC @err=sp_OAGetProperty @xPtr,'ResponseText',@x OUT
SELECT v
FROM
(SELECT CAST(STUFF(@x,1,CHARINDEX('>',@x),'') AS XML) x) a
CROSS APPLY
(SELECT a.x.query('//field/text()') v) b
/*
北京市XX路XX号
*/