ÎÒÓÃinsert·½·¨²åÈ룬ÄÚÈÝÉÙÕý³££¬µ«³¬³ö2mµÄÄÚÈݾÍû·¨Ð´È룬ÇëÎÊÊÇʲôÔÒò£¿
¿ÉÊÇÎÒ³¬¹ý2m¾Íд²»½øÈ¥ÁËѽ
ÓÃʲôÓï¾ä²åÈëµÄ£¿±¨Ê²Ã´´íÎó£¿
ÒýÓÃ
ÎÒÓÃinsert·½·¨²åÈ룬ÄÚÈÝÉÙÕý³££¬µ«³¬³ö2mµÄÄÚÈݾÍû·¨Ð´È룬ÇëÎÊÊÇʲôÔÒò£¿
ÊÇ <root>
<node>XX </ ......
ÔÚµ÷ÓÃwebservice µÄÒ»¸ö·½·¨£¬·µ»Øxmlnode £¬Ôõô°ÑÕâÑùµÄÊý¾Ý²åÈëµ½ Êý¾Ý¿â£¬´úÂëÔõôд
·µ»ØµÄxml ÈçÏÂ
<?xml version="1.0" encoding="utf-8" ?>
- <SceneryInfo>
- <scenery>
<id>16188 </id>
......
ÎÒÃÇʹÓÃ:
select * from mytb
FOR XML AUTO
½«µÃµ½µÄ½á¹ûÒÔXML·½Ê½Õ¹Ê¾³öÀ´,¼ÙÈçÎÒ¶¨ÒåÁËÒ»¸ö±äÁ¿
declare @a nvarchar(max)
ÄÜ·ñ°ÑÉú³ÉµÄXML´æ·Åµ½@aÀïÃæÄØ?
»»¾ä»°Ëµ,ÎÒÏ£Íû¶Ô²éѯ½á¹û½øÐÐÐòÁл¯,ÐèÒªµÄʱºò,ÔÙ·´ÐòÁл¯.
À÷º¦,¹þ¹þ,ÔÀ´ÕâôÓõÄ
¼ÈÈ»ÒѾµÃµ½XMLÁË,ÄÜ·ñ·´¹ýÀ´,°ÑXMLµÄ¶«Î÷× ......
½á¹¹ÈçÏÂ
XML code:
<process-definition>
<start-state name='start' push=''>
<transition to='analyse' >
</transition>
<title>PROJECT</title>
<url>/BIZ/1</url>
<power>*</power>
< ......
ÏëѧϰÏÂXML
ѧϰaspʱ£¬Ñ§¹ýÒ»µãHTML£¬ÕÒÁËÒ»±¾µç×Ó¹¤Òµ³ö°æÉçµÄXML´ÓÈëÃŵ½¾«Í¨£¬¿´ÁËÁùÕ£¬¸Ð¾õдµÄÌ«¶àÀíÂÛ£¬Ò»µãʵ¼ùҲûÓУ¬¿´²»¶®¡£
²»ÖªµÀ´ó¼ÒÓÐʲô±È½ÏºÃµÄÈëÃŽ̲Ä
http://www.ibook8.com/
²¹³äһϣ¬ÎÒÏÖÔÚÔÚѧϰjava¡¢JSP
ºÍÂ¥Ö÷ͬ·
ÕÒÁËÈý¸öѧϰxmlµÄ×ÊÁÏ£¬ÉÏ´«µ½ÎÒµÄ×ÊÔ´ÁË£º
ÎÞ·Ï»°xml ......
ÒѾÕÒµ½½â¾ö°ì·¨£¬µ«·Ç³£²»°²È«¡£
ÏîÄ¿·¢²¼ÔÚIIS·þÎñÆ÷µçÄÔµÄDÅÌÀÎÒÉèÖÃÁËDÅ̵ÄÓû§£¬Ìí¼ÓÁËÒ»¸ö¡°everyone¡±µÄÓû§£¬ÕâÑùµÄÒâ˼ÊDz»ÊǾÍÊÇ˵ÈκÎÈ˶¼¿ÉÒÔÐÞ¸ÄDÅÌÀïµÄÎļþÁË£¿
ÓÐûÓÐʲôÓû§Ãû³ÆÊÇÖ»Õë¶Ô·¢²¼µÄÏîÄ¿¶ÔÓÚXMLÎļþ²Ù×÷µÄ£¿{{ ......