sql2008ÄÜ´æ¶à´óµÄxmlÎĵµ
ÎÒÓÃinsert·½·¨²åÈ룬ÄÚÈÝÉÙÕý³££¬µ«³¬³ö2mµÄÄÚÈݾÍû·¨Ð´È룬ÇëÎÊÊÇʲôÔÒò£¿
¿ÉÊÇÎÒ³¬¹ý2m¾Íд²»½øÈ¥ÁËѽ
ÓÃʲôÓï¾ä²åÈëµÄ£¿±¨Ê²Ã´´íÎó£¿
ÊÇ <root>
<node>XX </node>
...
</root>
»¹ÊÇ <root> <node>XX </node>.. </root>
ÇëÌṩ±¨´íÐÅÏ¢
×î´óÖ§³Ö2GBµÄÎļþ,µ«ÊÇÈç¹ûÓÃÓï¾ä²åÈë,±ØÐëÉùÃ÷²åÈëµ½µÃÊÇxml±äÁ¿Àï.
2g
insert into introxml(text) values(sting)
textÊÇÒ»¸öxmlÀàÐ͵ÄÁÐÃû
stringÊÇͨ¹ý³ÌÐò¶Á³öµÄxmlÎĵµµÄÄÚÈÝ
Ö´ÐÐinsertʱ²»»á±¨´í
µ«ÊÇÈç¹ûÎĵµ´óÓÚ2m£¬²é¿´select³öÀ´µÄxmlÁУ¬ºó°ë²¿·ÖÄÚÈݾÍÊÇȱʧµÄ
SQL code:
-- ÊÔÊÔÕâÌõÓï¾ä
insert into introxml(text)
SELECT * from OPENROWSET(BULK 'c:\SampleFolder\SampleData.xml', SINGLE_BLOB) AS x
Õâ¸öÎÒÒ²ÊÔ¹ý µ«Êǽá¹ûÏàͬ »¹ÓÐÇëÎÊÄǸö2gµÄÏÞÖÆÔÚÄÄÀïÓÐÌáµ½ÄØ ÎÒ²éÁ˺þö¼Ã»²éµ½µÄ
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔÏ°¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»ÁË°¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ÎÒÔÚ±àдһ¸öwince5.0µÄ³ÌÐò£¬ÏëʵÏÖ°ÑPDAÉϵÄÒ»¸öLIST <STRING>ÀàÐ͵ÄÊý¾ÝÐòÁл¯ÎªXML£¬È»ºóÔÚPCÉϵÄÒ»¸öwebserviceÄõ½Õâ¸öXML£¬×ª»¯ÎªDataset£¬¸üÐÂPCÉϵÄÊý¾Ý¿â£¬ÎÒÏëÎÊÔõô°ÑXML´«¸øwebserviceµÄÄØ£¿
......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......