22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @x XML
SET @x = '
<ModifyMember_Input xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ListOfMemberModIoV1 xmlns="http://www.siebel.com/xml/%20Member%20Mod%20IO%20v1">
<LoyMember>
<Control1>0</Control1>
<Description />
<RegisterTime>2010-01-21 17:20:00</RegisterTime>
<CardActive>Y</CardActive>
<ListOfContact>
<Contact>
<Alias />
<FullName>AAA</FullName>
</Contact>
</ListOfContact>
<ListOfLOYMember_FetchInfoMethod />
</LoyMember>
</ListOfMemberModIoV1>
</ModifyMember_Input>'
select @x
select RegisterTime = @x.value('(/ModifyMember_Input/ListOfMemberModIoV1/LoyMember/RegisterTime)[1]', 'varchar(255)')
,FullName = @x.value('(/ModifyMember_Input/ListOfMemberModIoV1/LoyMember/ListOfContact/Contact/FullName)[1]', 'varchar(255)')