Ò»¸ö½âÎöxmlµÄÎÊÌâ,¼±
ÒÔÏ´úÂë,ÔÚSQL Server 2005ÏÂÖ´ÐÐ,ΪʲôµÃ²»µ½ÎÒÏëÒªµÄÖµÄØ?
ÎÒÏëµÃµ½Õâ¸öxmlÖеÄij¸öÔªËØÖµ,±ÈÈç:RegisterTimeºÍFullName.
ÎÒµÄSQLÎÊÌâ³öÔÚÄÄÀï?»òÕßÓиüºÃµÄ½â¾ö°ì·¨?лл´ó¼Ò.
SQL code:
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)')
ÄãÏëµÃµ½Ê²Ã´Öµ°¡?
ÎÊÌâ³öÔÚÃüÃû¿Õ¼äÉÏ£¬ÄãµÄ´úÂëÈ¥µôÃüÃû¿Õ¼äÊǺÃʵġ£
ÈçºÎÔÚÓÐ
Ïà¹ØÎÊ´ð£º
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
<?xml version="1.0" encoding="UTF-8" ?>
<root>
<video>
<device deviceid="\\?\usb#vid_0c45&pid_613b#5&2d0620de& ......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎĶ¼¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿
ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......
ÓÐÒ»¸öXML
XML code:
<Person>
<Node>
<Name>admin</Name>
<Date>2010-4-6</Date>
</Node>
<Node>
<Name>lisi</Name>
......