Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

FOR XMLÓï·¨µ¼³öXMLµÄÒ×´íÖ®´¦

Ô­ÎĵØÖ·£ºhttp://www.cnblogs.com/zhengyun_ustc/archive/2006/06/29/sqlxml_forxmlexplicit.html
[SQLXML]FOR XMLÓï·¨µ¼³öXMLµÄÒ×´íÖ®´¦
Version
Date
Creator
Description
1.0.0.1
2006-6-29
Ö£êÀ@Ultrapower
²Ý¸å
 
¼ÌÐøÔĶÁ֮ǰ£¬ÎÒÃǼÙÉèÄúÊìϤÒÔÏÂ֪ʶ£º
n         MS SQL Server 2000
n         Sp_makewebtask
n         FOR XML ×Ó¾ä
Èç¹û²»ÊìϤÕâЩ֪ʶµã£¬¿ÉÒÔ¿´ÏÂÃæÁ½Ð¡½Ú[×¼±¸¹¤×÷Ò»£ºFOR XML]ºÍ[×¼±¸¹¤×÷¶þ£ºsp_makewebtask]£»·ñÔò¿ÉÒÔÖ±½ÓÌø¹ý¡£
[×¼±¸¹¤×÷Ò»£ºFOR XML]
¹Ø¼ü´Ê£º      FOR XML AUTO/EXPLICIT¡£
¹¦ÄÜ£º          ¿ÉÒÔ¶ÔÏÖÓеĹØϵÊý¾Ý¿âÖ´ÐÐ SQL ²éѯ£¬ÒÔ·µ»Ø XML ÎĵµÐÎʽ¶ø²»ÊDZê×¼Ðм¯µÄ½á¹û¡£ÈôÒªÖ±½Ó¼ìË÷½á¹û£¬ÇëʹÓà SELECT Óï¾äµÄ FOR XML ×Ӿ䣬²¢ÇÒÔÚ FOR XML ×Ó¾äÖÐÖ¸¶¨ÏÂÁÐ XML ģʽ֮һ£º
l         RAW
l         AUTO
l         EXPLICIT
ÕâЩģʽ½öÔÚÉèÖÃËüÃǵIJéѯִÐÐʱÓÐЧ¡£ËüÃǶԺóÃæÖ´ÐеÄÈκβéѯµÄ½á¹ûûÓÐÓ°Ïì¡£³ýÁËÖ¸¶¨ XML ģʽÍ⣬»¹¿ÉÒÔÇëÇó XML-Data ¼Ü¹¹¡£
 
ÒýÉ꣺          ÔÚʵ¼Ê¹¤×÷ÖУ¬¿Ï¶¨»á¾­³£Óöµ½Òª×Ô¼ºÈ¥²éѯÊý¾Ý¿âÈ»ºó×éÖ¯Ò»¸öXMLÎĵµµÄÐèÇó£¬Õâʱºò¾Í¿ÉÒÔÖ±½ÓÓÃFOR XMLÓï·¨¡£
¾ÙÒ»¸ö×î¼òµ¥µÄÀý×Ó£º
Sql script
Use pubs
 
SELECT TOP 2 title_id, title, type
       from titles FOR XML AUTO, ELEMENTS
ÄÇô£¬Êä³ö½á¹û¾ÍÊÇ£º
Sql result
XML_F52E2B61-18A1-11d1-B105-00805F49916B
-----------------------------------------------------------------------------------
<titles>
       <title_id>BU1032</title_id>
       <title>The Busy Executive&apos;s Database Guide</title>
       <type>business    </type>
</titles


Ïà¹ØÎĵµ£º

ÔÚ.net µ±ÖÐÈçºÎXMLÐòÁл¯Ò»¸öCollection

CollectionÖ÷ÒªÊÇÖ¸ÏñArray, ArrayList, List, Dictionary, HashTableÕâЩÊý¾ÝÀàÐÍ£¬´ó¼ÒƽʱÓõĺܶࡣÈç¹ûÒ»¸öÀàÖÐÓÐÒ»¸öCollectionÀàÐ͵ijÉÔ±£¬ÔÚ¶ÔÕâ¸öÀà½øÐÐXMLÐòÁл¯µÄʱºò£¬Ó¦¸ÃÈçºÎ´¦Àí£¿Ó¦¸Ã˵ÔÚ.netµ±ÖÐÕâÊDZȽϼòµ¥µÄ£¬Ö»Òª½¨Á¢Ò»¸öXmlSerializerÀà¾Í¿ÉÒÔ°ïÄã×Ô¶¯¸ã¶¨£¬²»¹ýÓеÄʱºòÄã¿ÉÄÜÐèÒª¶Ô×Ô¶¯µÄÐòÁл¯¹ý³ ......

Symbianѧϰ±Ê¼Ç(16) ½âÎöXMLÎļþ(ÏÂ)


×ÖºÅ:  С  ÖР ´ó  | ´òÓ¡ ·¢²¼: 2009-1-08 16:33    ×÷Õß: webmaster    À´Ô´: ±¾Õ¾Ô­´´    ²é¿´: 40´Î
Êé½ÓÉϻأ¬Õâƪ½éÉÜÄǸöMContentHandlerµÄʵÏÖ£¬ÕâÊÇSAX½âÎö·½·¨µÄºËÐÄËùÔÚ¡£
ÏÈ¿´¿´ÎÒÒª½âÎöµÄXMLÎļþÈçÏÂËùʾ£¬ÆäʵºÜ¼òµ¥£¬ÒòΪËü³ýÁËEle ......

XMLѧϰ±Ê¼Ç£¨¶þ£©——XMLÔªËØÓëÊôÐÔ


XML ÔªËØ
ÔªËØÃüÃû
XMLÔªËرØÐë×ñÊØÒÔϵÄÃüÃû¹æÔò£º
Ãû×Ö¿É°üº¬×Öĸ¡¢Êý×ÖÒÔ¼°ÆäËûµÄ×Ö·û
Ãû×Ö²»ÄÜÒÔÊý×Ö»òÕß±êµã·ûºÅ¿ªÊ¼
Ãû×Ö²»ÄÜÒÔ×Ö·û“xml”£¨»òÕßXML¡¢Xml£©¿ªÊ¼
Ãû×Ö²»ÄÜ°üº¬¿Õ¸ñ
µ±Äú“·¢Ã÷´´Ôì”ÔªËØÃû³Æʱ£¬ÇëÁôÒâ²¢×ñÑ­ÏÂÃæµÄ¼òµ¥µÄ¹æÔò£º
Äú¿ÉÒÔʹÓóý±£Áô×ÖÍâµÄÈκÎÃû³Æ£ ......

xml °²×°bug

[Bug 230608] missing config.h in latest -14
Ralf Corsepius rc040203 at freenet.de
Tue Mar 6 13:31:13 UTC 2007
Previous message: [Bug 230608] missing config.h in latest -14
Next message: [Bug 230608] missing config.h in latest -14
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ