mssqlÖÐÓÃxmlµÄ·½·¨²ð·ÖÒÔ²»¶¨¿Õ¸ñΪ·Ö¸î·ûºÅµÄ×Ö·û´®
---xml²ð·ÖÒÔ²»¶¨¿Õ¸ñΪ·Ö¸î·ûºÅµÄ×Ö·û´®
--²âÊÔÊý¾Ý
if object_id('[tb]') is not null drop table [tb]
create table [tb]([a] varchar(200))
go
insert [tb]
select 'aaaa bbbb cccc dddd'
insert [tb]
select 'eeeeee ffff hhhh yyyy '
--¿ªÊ¼²éѯ
select
rtrim(A.A) as a,B.A2
from (
select a,convert(xml,'<root><row>'+replace(replace(rtrim(ltrim(a)),' ','</row><row>'),'<row></row>','')+'</row></root>') AS A1
from [tb]
) a outer apply (select a2=T.C.value('.','nvarchar(100)') from a.a1.nodes('/root/row')T(C)) B
/*
a A2
-------------------------------------------------------------------------- --------------------
aaaa bbbb cccc dddd aaaa
aaaa bbbb cccc dddd &nb
Ïà¹ØÎĵµ£º
JDOM ÊÇÒ»¸ö¿ªÔ´µÄ´¿java API,ÓÃÓÚ¿ìËÙ¿ª·¢ XML Ó¦ÓóÌÐò,JDOM½«XMLÎĵµ±íʾΪÊ÷£¬°üÀ¨ÔªËØ¡¢ÊôÐÔ¡¢ËµÃ÷¡¢´¦ÀíÖ¸Áî¡¢Îı¾½Úµã¡¢CDATA¶Î£¬µÈµÈ¡£JDOM¿ÉÒÔËæʱ·ÃÎÊÊ÷ÖеÄÈÎÒⲿ·Ö¡£Ê÷ÖÐËùÓв»Í¬½Úµã¾ùΪ¾ßÌåµÄÀà¡£ÔÚhttp://jdom.org¿ÉÒÔÏÂÔØJDOMµÄ×îа汾(ÎÒÕâÀïÊÇ1.0)¡£ÏÂÔغó½âѹ£¬JDOMµÄjarÎļþ¾ÍÊÇbuildÄ ......
ÓÉÓÚÏÖÔÚÔÚ¹«Ë¾¸ºÔðÖÆ×÷±ê×¼µÄ¾²Ì¬Ò³Ã棬ΪÁËÔöÇ¿¿Í»§ÌåÑ飬ËùÒÔ¾³£Òª×öЩAJAXЧ¹û£¬Ò²Ñ§ÄãÒ²ºÍÎÒÒ»ÑùÔÚ£¬Ñ§Ï°AJAX¡£¶øÉè¼ÆAJAXʱʹÓõÄÒ»¸öÖØÒªµÄ¼¼Êõ£¨¹¤¾ß£©¾ÍÊÇXMLHTTPRequest¶ÔÏóÁË¡£ÕâÀﺣХ°ÑÎÒѧϰXMLHTTPRequest¶ÔÏóµÄÒ»µã×ÊÁÏÄóöÀ´¸ú´ó¼ÒÒ»Æð·ÖÏí¡£ÎÄÖеÄ×ÊÁ϶¼ÊǺ£Ð¥ÔÚѧϰʱÔÚÍøÉÏÊÕ¼¯µÄ£¬Èç¹ûÄú¿ª¹ý£¬ÄǾÍÔÙ ......
--1. ´´½¨±í£¬Ìí¼Ó²âÊÔÊý¾Ý
CREATE TABLE tb(id int, [value] varchar(10))
INSERT tb SELECT 1, 'aa'
UNION ALL SELECT 1, 'bb'
UNION ALL SELECT 2, 'aaa'
UNION ALL SELECT 2, 'bbb'
UNION ALL SELECT 2, 'ccc'
--SELECT * from tb
/**//*
id value
----------- ----------
1 aa
1 bb
2 aaa
......
XmlDocument doc = new XmlDocument();
string strtxt = "";
doc.Load(Server.MapPath("XMLFile1.xml"));
&nbs ......